public static string MedDetails(string MedName)
{
IssueHeaderDetails IssuedtlsObj = new IssueHeaderDetails();
UIClasses.Const Const = new UIClasses.Const();
ClinicDAL.UserAuthendication UA;
UA = (ClinicDAL.UserAuthendication)HttpContext.Current.Session[Const.LoginSession];
IssuedtlsObj.ClinicID = UA.ClinicID.ToString();
DataSet ds = IssuedtlsObj.GetMedicineDetailsByMedicineName(MedName);
string Unit = "";
string MedCode = "";
string Category = "";
string Qty = "";
if (ds.Tables[0].Rows.Count > 0)
{
Unit = Convert.ToString(ds.Tables[0].Rows[0]["Unit"]);
MedCode = Convert.ToString(ds.Tables[0].Rows[0]["MedCode"]);
Category = Convert.ToString(ds.Tables[0].Rows[0]["CategoryName"]);
Qty = Convert.ToString(ds.Tables[0].Rows[0]["Qty"]);
}
return String.Format("{0}" + "|" + "{1}" + " | " + "{2}" + " | " + "{3}", Unit, MedCode, Category, Qty);
}