/// <summary> /// Saves a record to the core_ledger_account table. /// </summary> public void Insert(core_ledger_account_Objects objCls) { MySqlConnection scon = Connectivity.Cls_Connection.getConnection(); MySqlCommand scom = new MySqlCommand("core_ledger_accountInsert", scon); scom.CommandType = CommandType.StoredProcedure; scom.Parameters.Add("COL_Id_Ledger_Account", MySqlDbType.Int32,0); scom.Parameters.Add("COL_Ledger_Account_Name", MySqlDbType.VarChar,45); scom.Parameters.Add("COL_Balance_Carried_Forward", MySqlDbType.Double,0); scom.Parameters.Add("COL_Created_Date", MySqlDbType.DateTime,0); scom.Parameters.Add("COL_Created_User", MySqlDbType.Int32,0); scom.Parameters.Add("COL_Edited_Date", MySqlDbType.DateTime,0); scom.Parameters.Add("COL_Edited_User", MySqlDbType.Int32,0); scom.Parameters.Add("COL_Is_Active", MySqlDbType.Bit,0); scom.Parameters["COL_Id_Ledger_Account"].Value = objCls.Id_Ledger_Account; scom.Parameters["COL_Ledger_Account_Name"].Value = objCls.Ledger_Account_Name; scom.Parameters["COL_Balance_Carried_Forward"].Value = objCls.Balance_Carried_Forward; scom.Parameters["COL_Created_Date"].Value = objCls.Created_Date; scom.Parameters["COL_Created_User"].Value = objCls.Created_User; scom.Parameters["COL_Edited_Date"].Value = objCls.Edited_Date; scom.Parameters["COL_Edited_User"].Value = objCls.Edited_User; scom.Parameters["COL_Is_Active"].Value = objCls.Is_Active; scon.Open(); scom.ExecuteNonQuery(); scon.Close(); }
/// <summary> /// Saves a record to the core_ledger_account table. /// </summary> public void Insert(core_ledger_account_Objects objCls) { MySqlConnection scon = Connectivity.Cls_Connection.getConnection(); MySqlCommand scom = new MySqlCommand("core_ledger_accountInsert", scon); scom.CommandType = CommandType.StoredProcedure; scom.Parameters.Add("COL_Id_Ledger_Account", MySqlDbType.Int32, 0); scom.Parameters.Add("COL_Ledger_Account_Name", MySqlDbType.VarChar, 45); scom.Parameters.Add("COL_Balance_Carried_Forward", MySqlDbType.Double, 0); scom.Parameters.Add("COL_Created_Date", MySqlDbType.DateTime, 0); scom.Parameters.Add("COL_Created_User", MySqlDbType.Int32, 0); scom.Parameters.Add("COL_Edited_Date", MySqlDbType.DateTime, 0); scom.Parameters.Add("COL_Edited_User", MySqlDbType.Int32, 0); scom.Parameters.Add("COL_Is_Active", MySqlDbType.Bit, 0); scom.Parameters["COL_Id_Ledger_Account"].Value = objCls.Id_Ledger_Account; scom.Parameters["COL_Ledger_Account_Name"].Value = objCls.Ledger_Account_Name; scom.Parameters["COL_Balance_Carried_Forward"].Value = objCls.Balance_Carried_Forward; scom.Parameters["COL_Created_Date"].Value = objCls.Created_Date; scom.Parameters["COL_Created_User"].Value = objCls.Created_User; scom.Parameters["COL_Edited_Date"].Value = objCls.Edited_Date; scom.Parameters["COL_Edited_User"].Value = objCls.Edited_User; scom.Parameters["COL_Is_Active"].Value = objCls.Is_Active; scon.Open(); scom.ExecuteNonQuery(); scon.Close(); }