public void Update(GJournalsDetails Details)
{
try
{
string SQL = "UPDATE tblGJournal SET " +
"Particulars = @Particulars, "+
"Status = @Status, "+
"TotalDebitAmount = @TotalDebitAmount, "+
"TotalCreditAmount = @TotalCreditAmount "+
"WHERE GJournalID = @GJournalID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmParticulars = new MySqlParameter("@Particulars", MySqlDbType.String);
prmParticulars.Value = Details.Particulars;
cmd.Parameters.Add(prmParticulars);
MySqlParameter prmStatus = new MySqlParameter("@Status", MySqlDbType.Int16);
prmStatus.Value = Details.Status.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmTotalDebitAmount = new MySqlParameter("@TotalDebitAmount", MySqlDbType.Decimal);
prmTotalDebitAmount.Value = Details.TotalDebitAmount;
cmd.Parameters.Add(prmTotalDebitAmount);
MySqlParameter prmTotalCreditAmount = new MySqlParameter("@TotalCreditAmount", MySqlDbType.Decimal);
prmTotalCreditAmount.Value = Details.TotalCreditAmount;
cmd.Parameters.Add(prmTotalCreditAmount);
MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID", MySqlDbType.Int64);
prmGJournalID.Value = Details.GJournalID;
cmd.Parameters.Add(prmGJournalID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public GJournalsDetails Details(long GJournalID)
{
try
{
string SQL = SQLSelect() + "WHERE GJournalID = @GJournalID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID", MySqlDbType.Int64);
prmGJournalID.Value = GJournalID;
cmd.Parameters.Add(prmGJournalID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
GJournalsDetails Details = new GJournalsDetails();
while (myReader.Read())
{
Details.GJournalID = GJournalID;
Details.Particulars = "" + myReader["Particulars"].ToString();
Details.Status = (AccountGJournalsStatus)Enum.Parse(typeof(AccountGJournalsStatus), myReader.GetString("Status"));
Details.TotalDebitAmount = myReader.GetDecimal("TotalDebitAmount");
Details.TotalCreditAmount = myReader.GetDecimal("TotalCreditAmount");
}
myReader.Close();
return(Details);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public long Insert(GJournalsDetails Details)
{
try
{
string SQL = "INSERT INTO tblGJournal (" +
"Particulars, " +
"Status, " +
"TotalDebitAmount, " +
"TotalCreditAmount" +
") VALUES (" +
"@Particulars, " +
"@Status, " +
"@TotalDebitAmount, " +
"@TotalCreditAmount" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmParticulars = new MySqlParameter("@Particulars", MySqlDbType.String);
prmParticulars.Value = Details.Particulars;
cmd.Parameters.Add(prmParticulars);
MySqlParameter prmStatus = new MySqlParameter("@Status", MySqlDbType.Int16);
prmStatus.Value = Details.Status.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmTotalDebitAmount = new MySqlParameter("@TotalDebitAmount", MySqlDbType.Decimal);
prmTotalDebitAmount.Value = Details.TotalDebitAmount;
cmd.Parameters.Add(prmTotalDebitAmount);
MySqlParameter prmTotalCreditAmount = new MySqlParameter("@TotalCreditAmount", MySqlDbType.Decimal);
prmTotalCreditAmount.Value = Details.TotalCreditAmount;
cmd.Parameters.Add(prmTotalCreditAmount);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return(iID);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
private void SaveRecord(string Sender)
{
ComputeGJournal(Sender);
GJournalsDetails clsDetails = new GJournalsDetails();
clsDetails.GJournalID = Convert.ToInt64(lblGJournalID.Text);
clsDetails.Particulars = txtRemarks.Text;
clsDetails.TotalDebitAmount = Convert.ToDecimal(lblTotalDebitAmount.Text);
clsDetails.TotalCreditAmount = Convert.ToDecimal(lblTotalCreditAmount.Text);
GJournals clsGJournals = new GJournals();
clsGJournals.GetConnection();
lblGJournalID.Text = clsGJournals.Insert(clsDetails).ToString();
clsGJournals.CommitAndDispose();
}
public long Insert(GJournalsDetails Details)
{
try
{
string SQL = "INSERT INTO tblGJournal (" +
"Particulars, " +
"Status, " +
"TotalDebitAmount, " +
"TotalCreditAmount" +
") VALUES (" +
"@Particulars, " +
"@Status, " +
"@TotalDebitAmount, " +
"@TotalCreditAmount" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmParticulars = new MySqlParameter("@Particulars",MySqlDbType.String);
prmParticulars.Value = Details.Particulars;
cmd.Parameters.Add(prmParticulars);
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = Details.Status.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmTotalDebitAmount = new MySqlParameter("@TotalDebitAmount",MySqlDbType.Decimal);
prmTotalDebitAmount.Value = Details.TotalDebitAmount;
cmd.Parameters.Add(prmTotalDebitAmount);
MySqlParameter prmTotalCreditAmount = new MySqlParameter("@TotalCreditAmount",MySqlDbType.Decimal);
prmTotalCreditAmount.Value = Details.TotalCreditAmount;
cmd.Parameters.Add(prmTotalCreditAmount);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public GJournalsDetails Details(long GJournalID)
{
try
{
string SQL = SQLSelect() + "WHERE GJournalID = @GJournalID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID",MySqlDbType.Int64);
prmGJournalID.Value = GJournalID;
cmd.Parameters.Add(prmGJournalID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
GJournalsDetails Details = new GJournalsDetails();
while (myReader.Read())
{
Details.GJournalID = GJournalID;
Details.Particulars = "" + myReader["Particulars"].ToString();
Details.Status = (AccountGJournalsStatus)Enum.Parse(typeof(AccountGJournalsStatus), myReader.GetString("Status"));
Details.TotalDebitAmount = myReader.GetDecimal("TotalDebitAmount");
Details.TotalCreditAmount = myReader.GetDecimal("TotalCreditAmount");
}
myReader.Close();
return Details;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void Update(GJournalsDetails Details)
{
try
{
string SQL = "UPDATE tblGJournal SET " +
"Particulars = @Particulars, " +
"Status = @Status, " +
"TotalDebitAmount = @TotalDebitAmount, " +
"TotalCreditAmount = @TotalCreditAmount " +
"WHERE GJournalID = @GJournalID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmParticulars = new MySqlParameter("@Particulars",MySqlDbType.String);
prmParticulars.Value = Details.Particulars;
cmd.Parameters.Add(prmParticulars);
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = Details.Status.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmTotalDebitAmount = new MySqlParameter("@TotalDebitAmount",MySqlDbType.Decimal);
prmTotalDebitAmount.Value = Details.TotalDebitAmount;
cmd.Parameters.Add(prmTotalDebitAmount);
MySqlParameter prmTotalCreditAmount = new MySqlParameter("@TotalCreditAmount",MySqlDbType.Decimal);
prmTotalCreditAmount.Value = Details.TotalCreditAmount;
cmd.Parameters.Add(prmTotalCreditAmount);
MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID",MySqlDbType.Int64);
prmGJournalID.Value = Details.GJournalID;
cmd.Parameters.Add(prmGJournalID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
