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);
}
