public Int32 Save(CreditBillItemDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "INSERT INTO tblCreditBillDetailss(CreditBillHeaderID, TransactionDate, Description, Amount, " + "TransactionTypeID, TransactionRefID, TerminalNoRefID, BranchIDRefID)VALUES(" + "@CreditBillHeaderID, @TransactionDate, @Description, @Amount, " + "@TransactionTypeID, @TransactionRefID, @TerminalNoRefID, @BranchIDRefID)"; cmd.Parameters.AddWithValue("CreditBillHeaderID", Details.CreditBillHeaderID); cmd.Parameters.AddWithValue("TransactionDate", Details.TransactionDate); cmd.Parameters.AddWithValue("Description", Details.Description); cmd.Parameters.AddWithValue("Amount", Details.Amount); cmd.Parameters.AddWithValue("TransactionTypeID", Details.TransactionTypeID); cmd.Parameters.AddWithValue("TransactionRefID", Details.TransactionRefID); cmd.Parameters.AddWithValue("TerminalNoRefID", Details.TerminalNoRefID); cmd.Parameters.AddWithValue("BranchIDRefID", Details.BranchIDRefID); cmd.CommandText = SQL; return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(CreditBillItemDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "INSERT INTO tblCreditBillDetailss(CreditBillHeaderID, TransactionDate, Description, Amount, " + "TransactionTypeID, TransactionRefID, TerminalNoRefID, BranchIDRefID)VALUES(" + "@CreditBillHeaderID, @TransactionDate, @Description, @Amount, " + "@TransactionTypeID, @TransactionRefID, @TerminalNoRefID, @BranchIDRefID)"; cmd.Parameters.AddWithValue("CreditBillHeaderID", Details.CreditBillHeaderID); cmd.Parameters.AddWithValue("TransactionDate", Details.TransactionDate); cmd.Parameters.AddWithValue("Description", Details.Description); cmd.Parameters.AddWithValue("Amount", Details.Amount); cmd.Parameters.AddWithValue("TransactionTypeID", Details.TransactionTypeID); cmd.Parameters.AddWithValue("TransactionRefID", Details.TransactionRefID); cmd.Parameters.AddWithValue("TerminalNoRefID", Details.TerminalNoRefID); cmd.Parameters.AddWithValue("BranchIDRefID", Details.BranchIDRefID); cmd.CommandText = SQL; return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public CreditBillItemDetails[] setArrayDetails(System.Data.DataTable dt) { System.Collections.ArrayList arrItems = new System.Collections.ArrayList(); CreditBillItemDetails Details = new CreditBillItemDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details = new CreditBillItemDetails(); Details.CreditBillDetailID = Int64.Parse(dr["CreditBillDetailID"].ToString()); Details.CreditBillHeaderID = Int64.Parse(dr["CreditBillHeaderID"].ToString()); Details.TransactionDate = DateTime.Parse(dr["TransactionDate"].ToString()); Details.Description = dr["Description"].ToString(); Details.Amount = decimal.Parse(dr["Amount"].ToString()); Details.TransactionTypeID = Int32.Parse(dr["TransactionTypeID"].ToString()); Details.TransactionRefID = Int64.Parse(dr["TransactionRefID"].ToString()); Details.TerminalNoRefID = dr["TerminalNoRefID"].ToString(); Details.BranchIDRefID = Int32.Parse(dr["BranchIDRefID"].ToString()); arrItems.Add(Details); } CreditBillItemDetails[] retDetails = new Data.CreditBillItemDetails[0]; if (arrItems.Count > 0) { retDetails = new Data.CreditBillItemDetails[arrItems.Count]; arrItems.CopyTo(retDetails); } return(retDetails); }
public Int64 Insert(CreditBillItemDetails Details) { try { Save(Details); return Int64.Parse(base.getLAST_INSERT_ID(this)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(CreditBillItemDetails Details) { try { Save(Details); return(Int64.Parse(base.getLAST_INSERT_ID(this))); } catch (Exception ex) { throw base.ThrowException(ex); } }
public CreditBillItemDetails setDetails(System.Data.DataTable dt) { CreditBillItemDetails Details = new CreditBillItemDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.CreditBillDetailID = Int64.Parse(dr["CreditBillDetailID"].ToString()); Details.CreditBillHeaderID = Int64.Parse(dr["CreditBillHeaderID"].ToString()); Details.TransactionDate = DateTime.Parse(dr["TransactionDate"].ToString()); Details.Description = dr["Description"].ToString(); Details.Amount = decimal.Parse(dr["Amount"].ToString()); Details.TransactionTypeID = Int32.Parse(dr["TransactionTypeID"].ToString()); Details.TransactionRefID = Int64.Parse(dr["TransactionRefID"].ToString()); Details.TerminalNoRefID = dr["TerminalNoRefID"].ToString(); Details.BranchIDRefID = Int32.Parse(dr["BranchIDRefID"].ToString()); } return(Details); }
public CreditBillItemDetails Details(Int64 CreditBillItemID) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE CreditBillItemID = @CreditBillItemID;"; cmd.Parameters.AddWithValue("@CreditBillItemID", CreditBillItemID); 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); CreditBillItemDetails Details = setDetails(dt); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public CreditBillItemDetails[] setArrayDetails(System.Data.DataTable dt) { System.Collections.ArrayList arrItems = new System.Collections.ArrayList(); CreditBillItemDetails Details = new CreditBillItemDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details = new CreditBillItemDetails(); Details.CreditBillDetailID = Int64.Parse(dr["CreditBillDetailID"].ToString()); Details.CreditBillHeaderID = Int64.Parse(dr["CreditBillHeaderID"].ToString()); Details.TransactionDate = DateTime.Parse(dr["TransactionDate"].ToString()); Details.Description = dr["Description"].ToString(); Details.Amount = decimal.Parse(dr["Amount"].ToString()); Details.TransactionTypeID = Int32.Parse(dr["TransactionTypeID"].ToString()); Details.TransactionRefID = Int64.Parse(dr["TransactionRefID"].ToString()); Details.TerminalNoRefID = dr["TerminalNoRefID"].ToString(); Details.BranchIDRefID = Int32.Parse(dr["BranchIDRefID"].ToString()); arrItems.Add(Details); } CreditBillItemDetails[] retDetails = new Data.CreditBillItemDetails[0]; if (arrItems.Count > 0) { retDetails = new Data.CreditBillItemDetails[arrItems.Count]; arrItems.CopyTo(retDetails); } return retDetails; }
public CreditBillItemDetails setDetails(System.Data.DataTable dt) { CreditBillItemDetails Details = new CreditBillItemDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.CreditBillDetailID = Int64.Parse(dr["CreditBillDetailID"].ToString()); Details.CreditBillHeaderID = Int64.Parse(dr["CreditBillHeaderID"].ToString()); Details.TransactionDate = DateTime.Parse(dr["TransactionDate"].ToString()); Details.Description = dr["Description"].ToString(); Details.Amount = decimal.Parse(dr["Amount"].ToString()); Details.TransactionTypeID = Int32.Parse(dr["TransactionTypeID"].ToString()); Details.TransactionRefID = Int64.Parse(dr["TransactionRefID"].ToString()); Details.TerminalNoRefID = dr["TerminalNoRefID"].ToString(); Details.BranchIDRefID = Int32.Parse(dr["BranchIDRefID"].ToString()); } return Details; }