public ActionResult FillDataByProductID(int ProductDetailsID)
{
obj.Gst = 0;
obj.DiscountValue = "";
DataSet dsProductDetail = new DataSet();
dsProductDetail = BL_obj.GetServicesDetailsforMedicalBills(ProductDetailsID);
if (dsProductDetail.Tables[0].Rows.Count > 0)
{
if (dsProductDetail.Tables[0].Rows[0]["Contain"].ToString().Trim() != "")
{
obj.Contain = Convert.ToDecimal((dsProductDetail.Tables[0].Rows[0]["Contain"].ToString().Trim()));
}
DataSet ds = new DataSet();
ds = BL_obj.GetGSTRatio();
if (dsProductDetail.Tables[0].Rows[0]["GST"].ToString() != "")
{
obj.Gst = Convert.ToDecimal(dsProductDetail.Tables[0].Rows[0]["GST"].ToString());
}
long Gstper = (int)obj.Gst;
string valueGst = Gstper + "%".ToString();
DataView dv1 = new DataView(ds.Tables[0], " GSTTAX = '" + valueGst + "' ", "", DataViewRowState.CurrentRows);
obj.DiscountValue = "0";
if (dv1.ToTable().Rows.Count > 0)
{
obj.DiscountValue = dv1.ToTable().Rows[0]["GstDiscValue"].ToString();
}
obj.netRate = dsProductDetail.Tables[0].Rows[0]["SalesRate"].ToString();
obj.QtyU = dsProductDetail.Tables[0].Rows[0]["Packing"].ToString();
obj.QtyL = dsProductDetail.Tables[0].Rows[0]["ProductLowerUnitName"].ToString();
obj.mrp = dsProductDetail.Tables[0].Rows[0]["MRP"].ToString();
if (Convert.ToDateTime(dsProductDetail.Tables[0].Rows[0]["ExpiryDate"].ToString()) < DateTime.Now)
{
obj.expiryDate = dsProductDetail.Tables[0].Rows[0]["ExpiryDate"].ToString();
// ucPatientMedicalBill1.lblExpirydate.ForeColor = Color.Red;
}
else
{
obj.expiryDate = dsProductDetail.Tables[0].Rows[0]["ExpiryDate"].ToString();
// ucPatientMedicalBill1.lblExpirydate.ForeColor = Color.Black;
}
}
return(new JsonResult {
Data = obj, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
