public bool Update_ProductLoan(BE_DirectSales NewUpdateBE)
{
SqlTransaction trans = null;
try
{
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = sqlconn.CreateCommand();
sqlconn.Open();
trans = sqlconn.BeginTransaction();
sqlcomm.CommandText = "Update_ProductLoan";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
sqlcomm.Parameters.AddWithValue("@DRS_ID", NewUpdateBE.DR_ID);
sqlcomm.Parameters.AddWithValue("@LoanReceivedDate", NewUpdateBE.LoanReceivedDate);
sqlcomm.Parameters.AddWithValue("@IsLoan", NewUpdateBE.IsLoan);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
trans.Commit();
sqlconn.Close();
sqlcomm.Dispose();
trans.Dispose();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
trans.Rollback();
return(false);
}
}
public bool Insert_DirectSalesM(BE_DirectSales NewINSBE)
{
SqlTransaction trans = null;
try
{
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = sqlconn.CreateCommand();
sqlconn.Open();
trans = sqlconn.BeginTransaction();
sqlcomm.CommandText = "Insert_Trans_DRSM";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
MaxID = GetMaxID();
NewINSBE.DR_ID = MaxID;
sqlcomm.Parameters.AddWithValue("@DRS_ID", NewINSBE.DR_ID);
sqlcomm.Parameters.AddWithValue("@DRS_Date", NewINSBE.DRS_Date);
sqlcomm.Parameters.AddWithValue("@ModifiedDate", NewINSBE.ModifiedDate);
sqlcomm.Parameters.AddWithValue("@DRS_Name", NewINSBE.DRS_Name);
sqlcomm.Parameters.AddWithValue("@MobileNo", NewINSBE.MobileNo);
sqlcomm.Parameters.AddWithValue("@Remarks", NewINSBE.Remarks);
sqlcomm.Parameters.AddWithValue("@IsLoan", NewINSBE.IsLoan);
sqlcomm.Parameters.AddWithValue("@Type", NewINSBE.Type);
sqlcomm.Parameters.AddWithValue("@IsActive", NewINSBE.IsActive);
sqlcomm.Parameters.AddWithValue("@Discount", NewINSBE.Discount);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
trans.Commit();
sqlconn.Close();
sqlcomm.Dispose();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, DataAccess.ProjectName);
trans.Rollback();
return(false);
}
}
public bool Update_DirectSales(BE_DirectSales NewUpdateBE)
{
SqlTransaction trans = null;
try
{
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = sqlconn.CreateCommand();
sqlconn.Open();
trans = sqlconn.BeginTransaction();
sqlcomm.CommandText = "Update_Trans_DRSM";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
sqlcomm.Parameters.AddWithValue("@DRS_ID", NewUpdateBE.DR_ID);
sqlcomm.Parameters.AddWithValue("@ModifiedDate", NewUpdateBE.ModifiedDate);
sqlcomm.Parameters.AddWithValue("@DRS_Name", NewUpdateBE.DRS_Name);
sqlcomm.Parameters.AddWithValue("@MobileNo", NewUpdateBE.MobileNo);
sqlcomm.Parameters.AddWithValue("@Remarks", NewUpdateBE.Remarks);
sqlcomm.Parameters.AddWithValue("@IsLoan", NewUpdateBE.IsLoan);
sqlcomm.Parameters.AddWithValue("@Discount", NewUpdateBE.Discount);
sqlcomm.Parameters.AddWithValue("@Type", NewUpdateBE.Type);
//sqlcomm.Parameters.AddWithValue("@SlipNo", NewUpdateBE.SlipNo);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
//Delete Detail of Direct Sales Table
sqlcomm.CommandText = "Delete_Trans_DRSD";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.AddWithValue("@DRS_ID", NewUpdateBE.DR_ID);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
//Deelte Stock Entry From Stock Table
sqlcomm.CommandText = "Delete_DirectSalesStock";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.AddWithValue("@TableID", NewUpdateBE.DR_ID);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
// Commeneted by shaban
//Delete Cash Entry From Cash Table
sqlcomm.CommandText = "Delete_DirectSalesCash";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
sqlcomm.Parameters.AddWithValue("@TableID", NewUpdateBE.DR_ID);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
trans.Commit();
sqlconn.Close();
sqlcomm.Dispose();
trans.Dispose();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
trans.Rollback();
return(false);
}
}
public bool Insert_DirectSalesD(BE_DirectSales NewINSBEDetail)
{
SqlTransaction trans = null;
try
{
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = sqlconn.CreateCommand();
sqlconn.Open();
trans = sqlconn.BeginTransaction();
sqlcomm.CommandText = "Insert_Trans_DRSD";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
//NewINSBEDetail.DR_ID = MaxID;
sqlcomm.Parameters.AddWithValue("@DRS_ID", NewINSBEDetail.DR_ID);
sqlcomm.Parameters.AddWithValue("@ItemID", NewINSBEDetail.ItemID);
sqlcomm.Parameters.AddWithValue("@ItemPrice", NewINSBEDetail.ItemPrice);
sqlcomm.Parameters.AddWithValue("@SalesPrice", NewINSBEDetail.SalesPrice);
sqlcomm.Parameters.AddWithValue("@Qty", NewINSBEDetail.Qty);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
sqlcomm.CommandText = "Insert_Stock";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
sqlcomm.Parameters.AddWithValue("@StockDate", DateTime.Now);
sqlcomm.Parameters.AddWithValue("@TableID", NewINSBEDetail.DR_ID);
sqlcomm.Parameters.AddWithValue("@TableName", "Trans_DRSM");
sqlcomm.Parameters.AddWithValue("@InsertionDate", DateTime.Now);
sqlcomm.Parameters.AddWithValue("@ItemID", NewINSBEDetail.ItemID);
sqlcomm.Parameters.AddWithValue("@Dr", 0);
sqlcomm.Parameters.AddWithValue("@Cr", NewINSBEDetail.Qty);
sqlcomm.Parameters.AddWithValue("@IpAddress", "192.168.7.60");
sqlcomm.Parameters.AddWithValue("@userID", NewINSBEDetail.UserID);
sqlcomm.Parameters.AddWithValue("@IsActive", 1);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
// Commented by shaban
sqlcomm.CommandText = "Insert_CashBalance";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
//string Ip = GetHostIP();
sqlcomm.Parameters.AddWithValue("@CashInDate", DateTime.Now);
sqlcomm.Parameters.AddWithValue("@TableID", NewINSBEDetail.DR_ID);
sqlcomm.Parameters.AddWithValue("@TableName", "Trans_DRSM");
sqlcomm.Parameters.AddWithValue("@Dr", NewINSBEDetail.NetAmount);
sqlcomm.Parameters.AddWithValue("@Cr", 0);
sqlcomm.Parameters.AddWithValue("@IpAddress", "192.168.7.0");
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
trans.Commit();
sqlconn.Close();
sqlcomm.Dispose();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
trans.Rollback();
return(false);
}
}
public bool Update_DirectSales(BE_DirectSales NewUpdateBE)
{
return(NewDALObj.Update_DirectSales(NewUpdateBE));
}
public bool Insert_DirectSalesD(BE_DirectSales NewINSBEDetail)
{
return(NewDALObj.Insert_DirectSalesD(NewINSBEDetail));
}
public bool Insert_DirectSalesM(BE_DirectSales NewINSBE)
{
return(NewDALObj.Insert_DirectSalesM(NewINSBE));
}
