public void Update_Record(BE_Welfare NewBEObj)
{
SqlTransaction sqlTransaction = (SqlTransaction)null;
try
{
string Qry = @"Update Trans_Welfare
set
AssignDate=@Date,
PersonName=@PersonName,
Amount=@Amount,
Description=@Description,
Modify_At=@Modify_At,
IsActive=@IsActive
where WelfareID=@welfareID";
SqlConnection sqlConnection = new SqlConnection(this.ConnString);
SqlCommand command = new SqlCommand(Qry, sqlConnection);
sqlConnection.Open();
sqlTransaction = sqlConnection.BeginTransaction();
command.Transaction = sqlTransaction;
command.CommandType = CommandType.Text;
command.CommandText = Qry;
command.Parameters.AddWithValue("@WelfareID", (object)NewBEObj.WelfareID);
command.Parameters.AddWithValue("@Date", (object)NewBEObj.AssignDate);
command.Parameters.AddWithValue("@PersonName", (object)NewBEObj.PersonName);
command.Parameters.AddWithValue("@Amount", (object)NewBEObj.Amount);
command.Parameters.AddWithValue("@Description", (object)NewBEObj.Description);
command.Parameters.AddWithValue("@Modify_At", (object)NewBEObj.Modify_At);
command.Parameters.AddWithValue("@IsActive", NewBEObj.IsActive);
command.ExecuteNonQuery();
command.Parameters.Clear();
sqlTransaction.Commit();
sqlConnection.Close();
command.Dispose();
sqlTransaction.Dispose();
}
catch (Exception ex)
{
int num = (int)MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Hand);
sqlTransaction.Rollback();
}
}
public void Insert_Record(BE_Welfare NewBEObj)
{
SqlTransaction sqlTransaction = (SqlTransaction)null;
try
{
string Qry = @"Insert into trans_Welfare(WelfareID,AssignDate,PersonName,Amount,Description,Created_At,Modify_At,IsActive)
Values
(@WelfareID,@Date,@PersonName,@Amount,@Description,@Created_At,@Modify_At,@IsActive)";
SqlConnection sqlConnection = new SqlConnection(this.ConnString);
SqlCommand command = new SqlCommand(Qry, sqlConnection);
sqlConnection.Open();
sqlTransaction = sqlConnection.BeginTransaction();
//command.CommandText = "INSERT INTO Trans_InvestmentPosting\r\n (InvestmentPostingID,InvestorsID, InvestmentDate, ModifiedDate, Amount, IsActive)\r\n VALUES (@InvestmentPostingID,@InvestorsID, @InvestmentDate, @ModifiedDate, @Amount, @IsActive)";
command.Transaction = sqlTransaction;
command.CommandType = CommandType.Text;
command.CommandText = Qry;
this.InvestmentPosting = int.Parse(DataAccess.GetMaxNO("WelfareID", "Trans_Welfare").ToString());
NewBEObj.WelfareID = this.InvestmentPosting;
command.Parameters.AddWithValue("@WelfareID", (object)NewBEObj.WelfareID);
command.Parameters.AddWithValue("@Date", (object)NewBEObj.AssignDate);
command.Parameters.AddWithValue("@PersonName", (object)NewBEObj.PersonName);
command.Parameters.AddWithValue("@Amount", (object)NewBEObj.Amount);
command.Parameters.AddWithValue("@Description", (object)NewBEObj.Description);
command.Parameters.AddWithValue("@Created_At", (object)NewBEObj.Created_At);
command.Parameters.AddWithValue("@Modify_At", (object)"1900-01-01");
command.Parameters.AddWithValue("@IsActive", NewBEObj.IsActive);
command.ExecuteNonQuery();
command.Parameters.Clear();
sqlTransaction.Commit();
sqlConnection.Close();
command.Dispose();
sqlTransaction.Dispose();
}
catch (Exception ex)
{
int num = (int)MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Hand);
sqlTransaction.Rollback();
}
}