public void InsertOpeningBalanceM(BE_OpeningBalance OPeningObjM)
{
SqlTransaction trans = null;
try
{
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = sqlconn.CreateCommand();
sqlconn.Open();
trans = sqlconn.BeginTransaction();
sqlcomm.CommandText = "Insert_OpeningBalanceM";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
long MaxID = GetMaxID();
sqlcomm.Parameters.AddWithValue("@OpeningBalanceID", MaxID);
sqlcomm.Parameters.AddWithValue("@OpeningDate", OPeningObjM.OpeningDate);
sqlcomm.Parameters.AddWithValue("@Remarks", OPeningObjM.Remarks);
sqlcomm.Parameters.AddWithValue("@UserID", OPeningObjM.UserID);
sqlcomm.Parameters.AddWithValue("@IsActive", OPeningObjM.IsActive);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
//sqlconn.Open();
trans.Commit();
sqlconn.Close();
sqlcomm.Dispose();
trans.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
trans.Rollback();
}
}
public void InsertOpeningBalanceDetail(BE_OpeningBalance ObjDet)
{
SqlTransaction trans = null;
try
{
//string IpAddress;
//IpAddress=GetHostIP();
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = sqlconn.CreateCommand();
sqlconn.Open();
trans = sqlconn.BeginTransaction();
sqlcomm.CommandText = "Insert_OpeningBalanceD";
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Transaction = trans;
sqlcomm.Parameters.AddWithValue("@OpeningBalanceID", ObjDet.OpeningBalanceID);
sqlcomm.Parameters.AddWithValue("@ItemID", ObjDet.ItemID);
sqlcomm.Parameters.AddWithValue("@Qty", ObjDet.ItemQty);
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", ObjDet.OpeningBalanceID);
sqlcomm.Parameters.AddWithValue("@TableName", "OpeningBalanceM");
sqlcomm.Parameters.AddWithValue("@InsertionDate", DateTime.Now);
sqlcomm.Parameters.AddWithValue("@ItemID", ObjDet.ItemID);
sqlcomm.Parameters.AddWithValue("@Dr", ObjDet.ItemQty);
sqlcomm.Parameters.AddWithValue("@Cr", 0);
sqlcomm.Parameters.AddWithValue("@Ipaddress", "172.16.100.87");
sqlcomm.Parameters.AddWithValue("@UserID", 1);
sqlcomm.Parameters.AddWithValue("@IsActive", 1);
sqlcomm.ExecuteNonQuery();
sqlcomm.Parameters.Clear();
trans.Commit();
sqlconn.Close();
sqlcomm.Dispose();
trans.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
public void InsertOpeningBalanceD(BE_OpeningBalance ObjDetail)
{
DAL_OpeningBalance NewObjDetail = new DAL_OpeningBalance();
NewObjDetail.InsertOpeningBalanceDetail(ObjDetail);
}
public void InsertOpeningBalanceM(BE_OpeningBalance ObjMaster)
{
DAL_OpeningBalance ObjMasterDAL = new DAL_OpeningBalance();
ObjMasterDAL.InsertOpeningBalanceM(ObjMaster);
}
