public GJournalsDebitDetails Details(long GJournalDebitID)
{
try
{
string SQL = "SELECT " +
"GJournalDebitID, " +
"GJournalID, " +
"a.ChartOfAccountID, " +
"ChartOfAccountCode, " +
"ChartOfAccountName, " +
"Amount " +
"FROM tblGJournalDebit a INNER JOIN tblChartOfAccount b " +
"ON a.ChartOfAccountID = b.ChartOfAccountID " +
"WHERE GJournalDebitID = @GJournalDebitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGJournalDebitID = new MySqlParameter("@GJournalDebitID", MySqlDbType.Int64);
prmGJournalDebitID.Value = GJournalDebitID;
cmd.Parameters.Add(prmGJournalDebitID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
GJournalsDebitDetails Details = new GJournalsDebitDetails();
while (myReader.Read())
{
Details.GJournalDebitID = GJournalDebitID;
Details.GJournalID = myReader.GetInt64("GJournalID");
Details.ChartOfAccountID = myReader.GetInt32("ChartOfAccountID");
Details.Amount = myReader.GetDecimal("Amount");
}
myReader.Close();
return(Details);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void Update(GJournalsDebitDetails Details)
{
try
{
string SQL = "UPDATE tblGJournalDebit SET " +
"GJournalID = @GJournalID, "+
"ChartOfAccountID = @ChartOfAccountID, "+
"Amount = @Amount "+
"WHERE GJournalDebitID = @GJournalDebitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID", MySqlDbType.Int64);
prmGJournalID.Value = Details.GJournalID;
cmd.Parameters.Add(prmGJournalID);
MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID", MySqlDbType.Int64);
prmChartOfAccountID.Value = Details.ChartOfAccountID;
cmd.Parameters.Add(prmChartOfAccountID);
MySqlParameter prmAmount = new MySqlParameter("@Amount", MySqlDbType.Decimal);
prmAmount.Value = Details.Amount;
cmd.Parameters.Add(prmAmount);
MySqlParameter prmGJournalDebitID = new MySqlParameter("@GJournalDebitID", MySqlDbType.Int64);
prmGJournalDebitID.Value = Details.GJournalDebitID;
cmd.Parameters.Add(prmGJournalDebitID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public long Insert(GJournalsDebitDetails Details)
{
try
{
string SQL = "INSERT INTO tblGJournalDebit (" +
"GJournalID, " +
"ChartOfAccountID, " +
"Amount" +
") VALUES (" +
"@GJournalID, " +
"@ChartOfAccountID, " +
"@Amount" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID",MySqlDbType.Int64);
prmGJournalID.Value = Details.GJournalID;
cmd.Parameters.Add(prmGJournalID);
MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID",MySqlDbType.Int64);
prmChartOfAccountID.Value = Details.ChartOfAccountID;
cmd.Parameters.Add(prmChartOfAccountID);
MySqlParameter prmAmount = new MySqlParameter("@Amount",MySqlDbType.Decimal);
prmAmount.Value = Details.Amount;
cmd.Parameters.Add(prmAmount);
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 GJournalsDebitDetails Details(long GJournalDebitID)
{
try
{
string SQL = "SELECT " +
"GJournalDebitID, " +
"GJournalID, " +
"a.ChartOfAccountID, " +
"ChartOfAccountCode, " +
"ChartOfAccountName, " +
"Amount " +
"FROM tblGJournalDebit a INNER JOIN tblChartOfAccount b " +
"ON a.ChartOfAccountID = b.ChartOfAccountID " +
"WHERE GJournalDebitID = @GJournalDebitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGJournalDebitID = new MySqlParameter("@GJournalDebitID",MySqlDbType.Int64);
prmGJournalDebitID.Value = GJournalDebitID;
cmd.Parameters.Add(prmGJournalDebitID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
GJournalsDebitDetails Details = new GJournalsDebitDetails();
while (myReader.Read())
{
Details.GJournalDebitID = GJournalDebitID;
Details.GJournalID = myReader.GetInt64("GJournalID");
Details.ChartOfAccountID = myReader.GetInt32("ChartOfAccountID");
Details.Amount = myReader.GetDecimal("Amount");
}
myReader.Close();
return Details;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void Update(GJournalsDebitDetails Details)
{
try
{
string SQL = "UPDATE tblGJournalDebit SET " +
"GJournalID = @GJournalID, " +
"ChartOfAccountID = @ChartOfAccountID, " +
"Amount = @Amount " +
"WHERE GJournalDebitID = @GJournalDebitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID",MySqlDbType.Int64);
prmGJournalID.Value = Details.GJournalID;
cmd.Parameters.Add(prmGJournalID);
MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID",MySqlDbType.Int64);
prmChartOfAccountID.Value = Details.ChartOfAccountID;
cmd.Parameters.Add(prmChartOfAccountID);
MySqlParameter prmAmount = new MySqlParameter("@Amount",MySqlDbType.Decimal);
prmAmount.Value = Details.Amount;
cmd.Parameters.Add(prmAmount);
MySqlParameter prmGJournalDebitID = new MySqlParameter("@GJournalDebitID",MySqlDbType.Int64);
prmGJournalDebitID.Value = Details.GJournalDebitID;
cmd.Parameters.Add(prmGJournalDebitID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
private void SaveDebit()
{
GJournalsDebitDetails clsDetails = new GJournalsDebitDetails();
clsDetails.GJournalID = Convert.ToInt64(lblGJournalID.Text);
clsDetails.ChartOfAccountID = Convert.ToInt32(cboAccount.SelectedItem.Value);
clsDetails.Amount = Convert.ToDecimal(txtAmount.Text);
GJournalsDebit clsGJournalsDebit = new GJournalsDebit();
clsGJournalsDebit.Insert(clsDetails);
clsGJournalsDebit.CommitAndDispose();
}
public long Insert(GJournalsDebitDetails Details)
{
try
{
string SQL = "INSERT INTO tblGJournalDebit (" +
"GJournalID, " +
"ChartOfAccountID, " +
"Amount" +
") VALUES (" +
"@GJournalID, " +
"@ChartOfAccountID, " +
"@Amount" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID", MySqlDbType.Int64);
prmGJournalID.Value = Details.GJournalID;
cmd.Parameters.Add(prmGJournalID);
MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID", MySqlDbType.Int64);
prmChartOfAccountID.Value = Details.ChartOfAccountID;
cmd.Parameters.Add(prmChartOfAccountID);
MySqlParameter prmAmount = new MySqlParameter("@Amount", MySqlDbType.Decimal);
prmAmount.Value = Details.Amount;
cmd.Parameters.Add(prmAmount);
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);
}
}