Monday, May 21, 2012

How to get Printable Contents and Non Printable Contents in Javascript



<script language="javascript" type="text/javascript">
function PopPrint() {
var originalContents = document.body.innerHTML;
var prtContent = document.getElementById('<%=Receipt.ClientID %>');
var printContents = prtContent.innerHTML;
document.body.innerHTML = printContents;
window.print();
document.body.innerHTML = originalContents;
}
</script>

Thursday, May 17, 2012

How to Get Filenames from Directory


DirectoryInfo di = new DirectoryInfo(@"E:\Empphoto\");
FileInfo[] files = di.GetFiles();
foreach (FileInfo f in files)
{
con.Open();
string Qry = "Insert into TblEmpPhoto(ImgNameWithExt,ImgName,ImgExt) Values (@ImgNameWithExt,@ImgName,@ImgExt);";
SqlCommand cmd = new SqlCommand(Qry, con);
cmd.Parameters.AddWithValue("@ImgNameWithExt", f.Name.ToString().ToUpper());
cmd.Parameters.AddWithValue("@ImgName", f.Name.Split('.')[0].ToString().ToUpper());
cmd.Parameters.AddWithValue("@ImgExt", f.Name.Split('.')[1].ToString().ToUpper());
cmd.ExecuteNonQuery();
con.Close();
}

Get FileName from Filepath




private string GetFileName(string hrefLink)
{
string[] parts = hrefLink.Split('/');
string fileName = "";
if (parts.Length > 0)
fileName = parts[parts.Length - 1];
else
fileName = hrefLink;
return fileName;
}



Wednesday, May 2, 2012

Linq IsNull for DateTime

var
result = from r in Dsdod.Tables[0].AsEnumerable()where r.IsNull("startdate") != true && r.IsNull("expirydate") != true && r.IsNull("category") != true && CurrentIST >= (r.Field<DateTime>("startdate")) && CurrentIST < (r.Field<DateTime>("expirydate"))select new { Id = r.Field<Int32>("adid"), PromoCode = r.Field<string>("category") };