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 DataSet BindSupplier(string prefix) { DataSet ds = new DataSet(); try { KeystoneProject.Models.Pharmacy.Purchase obj = new Models.Pharmacy.Purchase(); Connect(); SqlCommand cmd = new SqlCommand("select ProductSupplierID , ProductSupplierName , ShortName ,ProductSupplier.Address ,DLNo,FoodLicNo,CreditDay,ProductSupplier.CSTNo,ProductSupplier.TINDate,Accounts.AccountName ,ContactPerson from ProductSupplier left join Accounts On Accounts.AccountsID = ProductSupplier.AccountsID where ProductSupplier.RowStatus = 0 and ProductSupplierName like '" + prefix + "%" + "' and ProductSupplier.HospitalID = " + HospitalID + " and ProductSupplier.LocationID = " + LocationID + " order by ProductSupplierName asc", con); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); con.Close(); } catch (Exception ex) { } return(ds); }
public DataSet BindBatchNoOfProduct(string ProductID) { DataSet ds = new DataSet(); try { KeystoneProject.Models.Pharmacy.Purchase obj = new Models.Pharmacy.Purchase(); Connect(); SqlCommand cmd = new SqlCommand("select ProductDetailsID ,BatchNo,ExpiryDate, PurchaseRate,MRP,SalesRate,CurrentStock ,CurrentStock1,ProductDetails.BarCode from ProductDetails left join Product on Product .ProductID = ProductDetails.ProductID where Product.HospitalID = " + HospitalID + " and Product.LocationID = " + LocationID + " and ProductDetails.ProductID =" + ProductID + " and ProductDetails.RowStatus = 0 order by ExpiryDate asc", con); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); con.Close(); } catch (Exception ex) { } return(ds); }