/// <summary> /// Return Account Number /// </summary> /// <param name="accountId"></param> /// <returns></returns> public string Update_Account_Number(int accountId) { string rt = ""; objAccount objAcc = new objAccount(); objAcc = Select(accountId); if (objAcc != null) { string accountPrefix = ""; if (!string.IsNullOrEmpty(objAcc.accountPrefix)) { accountPrefix = objAcc.accountPrefix; rt = Generate_Account_Number(objAcc.accountPrefix); } else { accountPrefix = Get_Prefix_For_Account(accountId); rt = Generate_Account_Number(accountPrefix); } objAcc.accountPrefix = accountPrefix; objAcc.accountNo = rt; Update(objAcc); } return(rt); }
public objAccount Get_Latest_Account_By_Prefix(string accountPrefix) { objAccount rt = new objAccount(); IDataReader idr = db.Select_Max_Account_By_Prefix(accountPrefix); rt = Select_Obj(idr); return(rt); }
public bool IsTransactable(int accountId) { objAccount objAcc = new objAccount(); objAcc = Select(accountId); bool rt = false; if (objAcc.accountIsTransactable == 1) { rt = true; } return(rt); }
public void Make_Account_Transactable(int accountId, bool isTransactable) { objAccount acc = new objAccount(); acc = Select(accountId); if (acc != null) { if (isTransactable == true) { acc.accountIsTransactable = 1; } else { acc.accountIsTransactable = 2; } Update(acc); } }
public string Generate_Account_Number(string accountPrefix) { string rt = "01"; objAccount objAcc = Get_Latest_Account_By_Prefix(accountPrefix); if (objAcc != null) { bool found = false; int accountId; found = int.TryParse(objAcc.accountNo.Replace("-", ""), out accountId); if (found) { rt = Convert.ToInt32(accountId + 1).ToString("00"); } } else { } return(rt); }
public objAccount Select(int accountID) { IDataReader idr = null; objAccount o = new objAccount(); try { idr = db.Select(accountID); o = Select_Obj(idr); } catch (Exception) { throw; } finally { if (idr != null) { idr.Dispose(); } } return(o); }
private objAccount Select_Obj(IDataReader idr) { objAccount o = new objAccount(); bool rtNull = true; if (idr != null) { while (idr.Read()) { rtNull = false; if (idr["accountID"] != DBNull.Value) { o.accountID = Convert.ToInt32(idr["accountID"]); } if (idr["accountPrefix"] != DBNull.Value) { o.accountPrefix = idr["accountPrefix"].ToString(); } if (idr["accountNo"] != DBNull.Value) { o.accountNo = idr["accountNo"].ToString(); } if (idr["accountLevel"] != DBNull.Value) { o.accountLevel = Convert.ToInt32(idr["accountLevel"]); } if (idr["accountParent"] != DBNull.Value) { o.accountParent = Convert.ToInt32(idr["accountParent"]); } if (idr["accountType"] != DBNull.Value) { o.accountType = Convert.ToInt32(idr["accountType"]); } if (idr["associateID"] != DBNull.Value) { o.associateID = Convert.ToInt32(idr["associateID"]); } if (idr["accountTitle"] != DBNull.Value) { o.accountTitle = Convert.ToString(idr["accountTitle"]); } if (idr["accountDescription"] != DBNull.Value) { o.accountDescription = Convert.ToString(idr["accountDescription"]); } if (idr["accountCreatedOn"] != DBNull.Value) { o.accountCreatedOn = Convert.ToDateTime(idr["accountCreatedOn"]); } if (idr["accountCreatedBy"] != DBNull.Value) { o.accountCreatedBy = Convert.ToInt32(idr["accountCreatedBy"]); } if (idr["accountLastUpdated"] != DBNull.Value) { o.accountLastUpdated = Convert.ToDateTime(idr["accountLastUpdated"]); } if (idr["accountLastUpdatedBy"] != DBNull.Value) { o.accountLastUpdatedBy = Convert.ToInt32(idr["accountLastUpdatedBy"]); } if (idr["accountLedger"] != DBNull.Value) { o.accountLedger = Convert.ToDecimal(idr["accountLedger"]); } if (idr["accountActual"] != DBNull.Value) { o.accountActual = Convert.ToDecimal(idr["accountActual"]); } if (idr["accountDefaultVersaAccount"] != DBNull.Value) { o.accountDefaultVersaAccount = Convert.ToInt32(idr["accountDefaultVersaAccount"]); } if (idr["accountIsBudgetDependent"] != DBNull.Value) { o.accountIsBudgetDependent = Convert.ToBoolean(idr["accountIsBudgetDependent"]); } if (idr["accountIsActive"] != DBNull.Value) { o.accountIsActive = Convert.ToBoolean(idr["accountIsActive"]); } if (idr["accountIsVisible"] != DBNull.Value) { o.accountIsVisible = Convert.ToBoolean(idr["accountIsVisible"]); } if (idr["accountIsTransactable"] != DBNull.Value) { o.accountIsTransactable = Convert.ToInt32(idr["accountIsTransactable"]); } if (idr["accountSystemIndex"] != DBNull.Value) { o.accountSystemIndex = Convert.ToInt32(idr["accountSystemIndex"]); } } } if (rtNull == true) { o = null; } return(o); }
public string Get_Prefix_For_Account(int accountId) { string rt = ""; objAccount objAcc = new objAccount(); objAcc = Select(accountId); if (objAcc != null) { if (!string.IsNullOrEmpty(objAcc.accountPrefix)) { rt = objAcc.accountPrefix; } else { if (objAcc.accountParent.HasValue) { if (objAcc.accountParent == 0) { if (string.IsNullOrEmpty(objAcc.accountNo)) { if (objAcc.accountType.HasValue) { iBiz.FinPro.Accounts.Categories bCat = new Categories(); Accounts.Categories.objCategory objCat = new Categories.objCategory(); objCat = bCat.Select(objAcc.accountType.Value); if (objCat != null) { rt = Convert.ToInt32(objCat.accCatID + 10).ToString("00"); } } } else { rt = objAcc.accountPrefix + objAcc.accountNo; } } else { int parentId = objAcc.accountParent.Value; objAcc = new objAccount(); objAcc = Select(parentId); if (objAcc != null) { if (!string.IsNullOrEmpty(objAcc.accountNo)) { rt = objAcc.accountPrefix + objAcc.accountNo; } else { Update_Account_Number(objAcc.accountID); } } } } } } return(rt); }
public void Update(objAccount i) { db.Update( i.accountID, i.accountPrefix, i.accountNo, i.accountLevel, i.accountParent, i.accountType, i.associateID, i.accountTitle, i.accountDescription, i.accountCreatedOn, i.accountCreatedBy, i.accountLastUpdated, i.accountLastUpdatedBy, i.accountLedger, i.accountActual, i.accountDefaultVersaAccount, i.accountIsBudgetDependent, i.accountIsActive, i.accountIsVisible, i.accountIsTransactable, i.accountSystemIndex); }