public Int32 Insert(AccountClassificationDetails 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(AccountClassificationDetails Details) { try { string SQL = "CALL procSaveAccountClassification(@AccountClassificationID, @AccountClassificationCode, @AccountClassificationName, @AccountClassificationType, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("AccountClassificationID", Details.AccountClassificationID); cmd.Parameters.AddWithValue("AccountClassificationCode", Details.AccountClassificationCode); cmd.Parameters.AddWithValue("AccountClassificationName", Details.AccountClassificationName); cmd.Parameters.AddWithValue("AccountClassificationType", Details.AccountClassificationType.ToString("d")); 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 Int32 Insert(AccountClassificationDetails 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 void Update(AccountClassificationDetails Details) { try { Save(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public AccountClassificationDetails Details(Int32 AccountClassificationID) { try { string SQL = SQLSelect() + "WHERE AccountClassificationID = @AccountClassificationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmAccountClassificationID = new MySqlParameter("@AccountClassificationID", MySqlDbType.Int16); prmAccountClassificationID.Value = AccountClassificationID; cmd.Parameters.Add(prmAccountClassificationID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); AccountClassificationDetails Details = new AccountClassificationDetails(); while (myReader.Read()) { Details.AccountClassificationID = AccountClassificationID; Details.AccountClassificationCode = "" + myReader["AccountClassificationCode"].ToString(); Details.AccountClassificationName = "" + myReader["AccountClassificationName"].ToString(); Details.AccountClassificationType = (AccountClassificationType)Enum.Parse(typeof(AccountClassificationType), myReader.GetString("AccountClassificationType")); } myReader.Close(); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(AccountClassificationDetails Details) { try { string SQL = "CALL procSaveAccountClassification(@AccountClassificationID, @AccountClassificationCode, @AccountClassificationName, @AccountClassificationType, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("AccountClassificationID", Details.AccountClassificationID); cmd.Parameters.AddWithValue("AccountClassificationCode", Details.AccountClassificationCode); cmd.Parameters.AddWithValue("AccountClassificationName", Details.AccountClassificationName); cmd.Parameters.AddWithValue("AccountClassificationType", Details.AccountClassificationType.ToString("d")); 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 AccountClassificationDetails Details(Int32 AccountClassificationID) { try { string SQL = SQLSelect() + "WHERE AccountClassificationID = @AccountClassificationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmAccountClassificationID = new MySqlParameter("@AccountClassificationID",MySqlDbType.Int16); prmAccountClassificationID.Value = AccountClassificationID; cmd.Parameters.Add(prmAccountClassificationID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); AccountClassificationDetails Details = new AccountClassificationDetails(); while (myReader.Read()) { Details.AccountClassificationID = AccountClassificationID; Details.AccountClassificationCode = "" + myReader["AccountClassificationCode"].ToString(); Details.AccountClassificationName = "" + myReader["AccountClassificationName"].ToString(); Details.AccountClassificationType = (AccountClassificationType) Enum.Parse(typeof(AccountClassificationType), myReader.GetString("AccountClassificationType")); } myReader.Close(); return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }