public JsonResult GetProductSupplier(string ProductSupplierID)
{
BL_Purchase db = new BL_Purchase();
DataSet dsBalance = new DataSet();
DataSet ds = new DataSet();
dsBalance = objbl.GetProductSupplier(ProductSupplierID);
ds = objbl.GetProductSupplier(ProductSupplierID);
List <Purchase> searchlist = new List <Purchase>();
foreach (DataRow dr in dsBalance.Tables[0].Rows)
{
searchlist.Add(new Purchase
{
ProductSupplierID = Convert.ToString(dr["ProductSupplierID"]),
ProductSupplierName = Convert.ToString(dr["ProductSupplierName"]),
Address = Convert.ToString(dr["Address"]),
Balance = dsBalance.Tables[1].Rows[0]["Balance"].ToString(),
});
}
return(new JsonResult {
Data = searchlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult AjaxMethod_CheckProduct(string productNameID1, FormCollection fc)
{
KeystoneProject.Buisness_Logic.Pharmacy.BL_Purchase BL_obj = new BL_Purchase();
KeystoneProject.Models.Pharmacy.Purchase obj = new Purchase();
List <string> searchList = new List <string>();
try
{
DataTable dt = new DataTable();
DataSet ds = BL_obj.Bind_Newproductdetail("%", productNameID1);
if (ds.Tables[0].Rows.Count > 0)
{
dt = BL_obj.Bind_PackQtyRate(Convert.ToInt16(ds.Tables[0].Rows[0]["ProductID"].ToString()));
obj.HSNSACCode1 = dt.Rows[0]["HSNSACCode"].ToString();
obj.gst1 = dt.Rows[0]["GST"].ToString();
obj.sgst1 = dt.Rows[0]["SGST"].ToString();
obj.cgst1 = dt.Rows[0]["CGST"].ToString();
obj.utgst1 = dt.Rows[0]["UTGST"].ToString();
searchList.Add(obj.HSNSACCode1);
searchList.Add(obj.gst1);
searchList.Add(obj.sgst1);
searchList.Add(obj.cgst1);
searchList.Add(obj.utgst1);
}
return(Json(searchList));
}
catch (Exception ex)
{
return(Json(searchList));
}
}
public JsonResult Delete_Purchase(int ProductPurchaseID)
{
string _Del = null;
try
{
KeystoneProject.Buisness_Logic.Pharmacy.BL_Purchase objdb = new BL_Purchase();
Purchase objSG = new Models.Pharmacy.Purchase();
int DependaincyName = objdb.DeletePurchase(ProductPurchaseID);
if (DependaincyName > 0)
{
_Del = "Purchase Deleted Successfully !";
}
else
{
_Del = "Purchase Can not be Deleted !";
}
}
catch (Exception ex)
{
throw ex;
}
return(new JsonResult {
Data = _Del, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetProductPurchaseOLDBillsNO(string ProductSupplierID)
{
BL_Purchase db = new BL_Purchase();
DataSet dsBalance = new DataSet();
DataSet ds = new DataSet();
dsBalance = objbl.GetProductPurchaseOLDBillsNO(ProductSupplierID);
ds = objbl.GetProductPurchaseOLDBillsNO(ProductSupplierID);
List <Purchase> searchlist = new List <Purchase>();
foreach (DataRow dr in dsBalance.Tables[0].Rows)
{
searchlist.Add(new Purchase
{
ProductSupplierID = Convert.ToString(dr["ProductSupplierID"]),
BillNo = Convert.ToString(dr["BillNo"]),
BillNoDate = Convert.ToString(dr["BillNo&Date"]),
});
}
return(new JsonResult {
Data = searchlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}