private bool UpdateMaster(mdlSaleReturn ObjmdlSaleReturn, SqlCommand cmd, SqlConnection con, SqlTransaction Transection) { bool UpdateMaster = false; cmd = new SqlCommand("stp_ERP_SaleReturn_Crud", con, Transection); cmd.Parameters.Add("@pk_ReturnId", SqlDbType.VarChar, 9).Value = ObjmdlSaleReturn.pk_ReturnId; cmd.Parameters.Add("@ReturnDate", SqlDbType.DateTime).Value = ObjmdlSaleReturn.ReturnDate; cmd.Parameters.Add("@GrossAmount", SqlDbType.Decimal).Value = ObjmdlSaleReturn.GrossAmount; cmd.Parameters.Add("@Discount", SqlDbType.Decimal).Value = ObjmdlSaleReturn.Discount; cmd.Parameters.Add("@SaleTax", SqlDbType.Decimal).Value = ObjmdlSaleReturn.SaleTax; cmd.Parameters.Add("@NetAmount", SqlDbType.Decimal).Value = ObjmdlSaleReturn.NetAmount; cmd.Parameters.Add("@TerritoryId", SqlDbType.VarChar, 6).Value = ObjmdlSaleReturn.TerritoryId; cmd.Parameters.Add("@InvoiceId", SqlDbType.VarChar, 9).Value = ObjmdlSaleReturn.InvoiceId; cmd.Parameters.Add("@ReturnType", SqlDbType.VarChar, 15).Value = ObjmdlSaleReturn.ReturnType; cmd.Parameters.Add("@EmployeeId", SqlDbType.VarChar, 6).Value = ObjmdlSaleReturn.EmployeeId; cmd.Parameters.Add("@CustomerId", SqlDbType.VarChar, 6).Value = ObjmdlSaleReturn.CustomerId; cmd.Parameters.Add("@Salebase", SqlDbType.Bit).Value = ObjmdlSaleReturn.Salebase; cmd.Parameters.Add("@SMReturn", SqlDbType.Bit).Value = ObjmdlSaleReturn.SMReturn; cmd.Parameters.Add("@RSSId", SqlDbType.VarChar, 9).Value = ObjmdlSaleReturn.RSSId; cmd.Parameters.Add("@OCGroupId", SqlDbType.VarChar, 6).Value = ObjmdlSaleReturn.OCGroupId; cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 16).Value = ObjmdlSaleReturn.AddUser; cmd.Parameters.Add("@Expiry", SqlDbType.Bit).Value = ObjmdlSaleReturn.Expiry; cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "UpdateSaleReturnM"; cmd.CommandType = CommandType.StoredProcedure; if (cmd.ExecuteNonQuery() != 0) { UpdateMaster = true; } cmd.Parameters.Clear(); return UpdateMaster; }
private bool SaveDetail(DataTable dt, SqlCommand cmd, SqlConnection con, SqlTransaction Transection, mdlSaleReturn ObjmdlSaleReturn) { bool SaveDetail = false; if (dt.Rows.Count > 0) { cmd = new SqlCommand("stp_ERP_SaleReturn_Crud", con, Transection); cmd.CommandType = CommandType.StoredProcedure; for (int i = 0; i <= dt.Rows.Count - 1; i++) { if (Convert.ToDouble(dt.Rows[i]["Qty"].ToString()) > 0) { cmd.Parameters.Add("@DReturnId", SqlDbType.VarChar, 9).Value = ObjmdlSaleReturn.pk_ReturnId; cmd.Parameters.Add("@DProductID", SqlDbType.VarChar, 6).Value = dt.Rows[i]["ID"].ToString().Replace("-", ""); cmd.Parameters.Add("@DStockType", SqlDbType.VarChar, 50).Value = dt.Rows[i]["Type"].ToString().Replace("-", ""); cmd.Parameters.Add("@DBatchNo", SqlDbType.VarChar, 15).Value = dt.Rows[i]["Batch No"].ToString(); cmd.Parameters.Add("@DExpiryDate", SqlDbType.DateTime).Value = Convert.ToDateTime(dt.Rows[i]["Exp. Date"]); cmd.Parameters.Add("@DManfactureDate", SqlDbType.DateTime).Value = Convert.ToDateTime(dt.Rows[i]["Mfg. Date"]); cmd.Parameters.Add("@DUnitPrice", SqlDbType.Decimal).Value = Convert.ToDecimal(dt.Rows[i]["FlatRate"]); cmd.Parameters.Add("@DQtyRtn", SqlDbType.Decimal).Value = dt.Rows[i]["Qty"]; cmd.Parameters.Add("@DDiscountPer", SqlDbType.Decimal).Value = dt.Rows[i]["Disc %"]; cmd.Parameters.Add("@DDiscount", SqlDbType.Decimal).Value = dt.Rows[i]["Discount"]; cmd.Parameters.Add("@DSTaxValue", SqlDbType.Decimal).Value = dt.Rows[i]["STaxValue"]; cmd.Parameters.Add("@DSaleTaxPer", SqlDbType.Decimal).Value = dt.Rows[i]["SaleTaxPer"]; cmd.Parameters.Add("@DSaleTaxAmount", SqlDbType.Decimal).Value = dt.Rows[i]["Sale Tax"]; cmd.Parameters.Add("@DNetAmount", SqlDbType.Decimal).Value = dt.Rows[i]["Net"]; cmd.Parameters.Add("@GrossAmount", SqlDbType.Decimal).Value = dt.Rows[i]["GrossValue"]; cmd.Parameters.Add("@DCostRate", SqlDbType.Decimal).Value = dt.Rows[i]["CostRate"]; cmd.Parameters.Add("@DFlatRate", SqlDbType.Decimal).Value = dt.Rows[i]["TP"]; cmd.Parameters.Add("@DAvgRate", SqlDbType.Decimal).Value = dt.Rows[i]["AvgRate"]; cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 20).Value = "InsertSaleReturnD"; if (cmd.ExecuteNonQuery() != 0) { SaveDetail = true; } else { SaveDetail = false; break; } cmd.Parameters.Clear(); } } } else { SaveDetail = false; } return SaveDetail; }
//--------------------------------------------SaveUpdate Sale Return---------------------------------------------------// public bool SaveUpdateSaleReturn(mdlSaleReturn ObjmdlSaleReturn, DataTable dtDetail, string SaveUpdate) { bool Save = false; SqlTransaction transaction; if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); transaction = con.BeginTransaction(); SqlCommand cmd = new SqlCommand("stp_ERP_SaleReturn_Crud", con, transaction); try { if (SaveUpdate == "Save") { if (SaveMaster(ObjmdlSaleReturn, cmd, con, transaction) && SaveDetail(dtDetail, cmd, con, transaction, ObjmdlSaleReturn)) { Save = true; transaction.Commit(); } else { transaction.Rollback(); } } else if (SaveUpdate == "Update") { if (DeleteDetail(cmd, con, transaction, ObjmdlSaleReturn) && UpdateMaster(ObjmdlSaleReturn, cmd, con, transaction) && SaveDetail(dtDetail, cmd, con, transaction, ObjmdlSaleReturn)) { Save = true; transaction.Commit(); } else { transaction.Rollback(); } } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { transaction.Rollback(); if (con.State == ConnectionState.Open) { con.Close(); } MessageBox.Show(ex.Message, "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Error); Save = false; } return Save; }
private bool DeleteDetail(SqlCommand cmd, SqlConnection con, SqlTransaction Transection, mdlSaleReturn ObjmdlSaleReturn) { bool DeleteDetail = false; cmd = new SqlCommand("Delete From D_SaleReturn WHERE [ReturnId] = '" + ObjmdlSaleReturn.pk_ReturnId + "'", con, Transection); cmd.CommandType = CommandType.Text; if (cmd.ExecuteNonQuery() != 0) { DeleteDetail = true; } cmd.Parameters.Clear(); return DeleteDetail; }
public bool SaveUpdateSaleReturn(mdlSaleReturn ObjmdlSaleReturn,DataTable dtDetail,string SaveUpdate) { return ObjdalSaleReturn.SaveUpdateSaleReturn(ObjmdlSaleReturn, dtDetail, SaveUpdate); }