/// <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);
}
