public Int32 Insert(AccountSummaryDetails Details) { try { Save(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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); Int32 iID = 0; foreach(System.Data.DataRow dr in dt.Rows) { iID = Int32.Parse(dr[0].ToString()); } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Insert(AccountSummaryDetails Details) { try { Save(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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); Int32 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int32.Parse(dr[0].ToString()); } return(iID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(AccountSummaryDetails Details) { try { string SQL = "CALL procSaveAccountSummary(@AccountSummaryID, @AccountClassificationID, @AccountSummaryCode, @AccountSummaryName, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("AccountSummaryID", Details.AccountSummaryID); cmd.Parameters.AddWithValue("AccountClassificationID", Details.AccountClassificationDetails.AccountClassificationID); cmd.Parameters.AddWithValue("AccountSummaryCode", Details.AccountSummaryCode); cmd.Parameters.AddWithValue("AccountSummaryName", Details.AccountSummaryName); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(AccountSummaryDetails Details) { try { Save(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void SaveRecord() { AccountSummaryDetails clsDetails = new AccountSummaryDetails(); clsDetails.AccountSummaryID = Convert.ToInt16(lblAccountSummaryID.Text); clsDetails.AccountClassificationDetails = new AccountClassificationDetails { AccountClassificationID = Convert.ToInt16(cboAccountClassification.SelectedItem.Value) }; clsDetails.AccountSummaryCode = txtAccountSummaryCode.Text; clsDetails.AccountSummaryName = txtAccountSummaryName.Text; AccountSummaries clsAccountSummary = new AccountSummaries(); clsAccountSummary.Update(clsDetails); clsAccountSummary.CommitAndDispose(); }
public AccountSummaryDetails Details(Int32 AccountSummaryID) { try { string SQL = SQLSelect() + "WHERE AccountSummaryID = @AccountSummaryID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmAccountSummaryID = new MySqlParameter("@AccountSummaryID", MySqlDbType.Int16); prmAccountSummaryID.Value = AccountSummaryID; cmd.Parameters.Add(prmAccountSummaryID); 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); AccountSummaryDetails Details = new AccountSummaryDetails(); AccountClassifications clsAccountClassification = new AccountClassifications(this.Connection, this.Transaction); foreach (System.Data.DataRow dr in dt.Rows) { Details.AccountSummaryID = AccountSummaryID; Details.AccountSummaryCode = "" + dr["AccountSummaryCode"].ToString(); Details.AccountSummaryName = "" + dr["AccountSummaryName"].ToString(); Details.AccountClassificationDetails = clsAccountClassification.Details(Int16.Parse(dr["AccountClassificationID"].ToString())); } return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public AccountSummaryDetails Details(Int32 AccountSummaryID) { try { string SQL = SQLSelect() + "WHERE AccountSummaryID = @AccountSummaryID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmAccountSummaryID = new MySqlParameter("@AccountSummaryID",MySqlDbType.Int16); prmAccountSummaryID.Value = AccountSummaryID; cmd.Parameters.Add(prmAccountSummaryID); 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); AccountSummaryDetails Details = new AccountSummaryDetails(); AccountClassifications clsAccountClassification = new AccountClassifications(this.Connection, this.Transaction); foreach (System.Data.DataRow dr in dt.Rows) { Details.AccountSummaryID = AccountSummaryID; Details.AccountSummaryCode = "" + dr["AccountSummaryCode"].ToString(); Details.AccountSummaryName = "" + dr["AccountSummaryName"].ToString(); Details.AccountClassificationDetails = clsAccountClassification.Details(Int16.Parse(dr["AccountClassificationID"].ToString())); } return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(AccountSummaryDetails Details) { try { string SQL = "CALL procSaveAccountSummary(@AccountSummaryID, @AccountClassificationID, @AccountSummaryCode, @AccountSummaryName, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("AccountSummaryID", Details.AccountSummaryID); cmd.Parameters.AddWithValue("AccountClassificationID", Details.AccountClassificationDetails.AccountClassificationID); cmd.Parameters.AddWithValue("AccountSummaryCode", Details.AccountSummaryCode); cmd.Parameters.AddWithValue("AccountSummaryName", Details.AccountSummaryName); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
private Int32 SaveRecord() { AccountSummaryDetails clsDetails = new AccountSummaryDetails(); clsDetails.AccountClassificationDetails = new AccountClassificationDetails { AccountClassificationID = Convert.ToInt16(cboAccountClassification.SelectedItem.Value) }; clsDetails.AccountSummaryCode = txtAccountSummaryCode.Text; clsDetails.AccountSummaryName = txtAccountSummaryName.Text; AccountSummaries clsAccountSummary = new AccountSummaries(); Int32 id = clsAccountSummary.Insert(clsDetails); clsAccountSummary.CommitAndDispose(); return id; }