public List <Company> GetCompanyRecords(string Subdomainname)
{
List <Company> lstCompany = new List <Company>();
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@domain", Subdomainname);
DataSet dsCompRecords = dataInterfaceSQL.GetDataSet("GetCompanyRecords", sqlParameter, false);
if (dsCompRecords.Tables.Count > 0 && dsCompRecords.Tables[0].Rows.Count > 0)
{
DataTable dtCompRecords = dsCompRecords.Tables[0];
lstCompany = dtCompRecords.AsEnumerable().Select(row => new Company {
Cocode = row.Field <string>("cocode"),
Coname = row.Field <string>("coname"),
Coystart = row.Field <string>("coystart"),
Cocity = row.Field <string>("cocity"),
Costate = row.Field <string>("costate"),
Copincode = row.Field <string>("copincode"),
}).ToList();
}
return(lstCompany);
}
public List <Accounting> GetAllAccounting()
{
List <Accounting> accountings = new List <Accounting>();
DataSet accountingData = dataInterfaceSQL.GetDataSet("select * from Accountings", null, false, false);
DataSet additionalData = dataInterfaceSQL.GetDataSet("select * from AdditionalData where [Table] = 'Accountings'", null, false, false);
if (accountingData.Tables.Count > 0)
{
accountings = accountingData.Tables[0].AsEnumerable()
.Select(row => new Accounting
{
Id = Convert.ToInt32(row["id"]),
SubId = Convert.ToInt32(row["SubId"]),
Desc = row["Desc"] == DBNull.Value ? "" : row["Desc"].ToString(),
Type = row["Type"] == DBNull.Value ? "" : row["Type"].ToString(),
HSNSAC = row["HSNSAC"] == DBNull.Value ? "" : row["HSNSAC"].ToString(),
GrpUnder = row["GrpUnder"] == DBNull.Value ? "" : row["GrpUnder"].ToString(),
Block = row["Block"] == DBNull.Value ? "" : row["Block"].ToString(),
Balance = row["Balance"] == DBNull.Value ? "" : row["Balance"].ToString(),
BalancePost = row["BalancePost"] == DBNull.Value ? "" : row["BalancePost"].ToString(),
NOF = row["NOF"] == DBNull.Value ? "" : row["NOF"].ToString(),
// CreatedDate = Convert.ToDateTime(row["CreatedDate"]),
// UpdatedDate = Convert.ToDateTime(row["UpdatedDate"]),
// IsDeleted = Convert.ToBoolean(row["IsDeleted"]),
AdditionalData = additionalData.Tables.Count > 0 && additionalData.Tables[0].Rows.Count > 0 ?
additionalData.Tables[0].AsEnumerable()
.Select(adrow => new AdditionalData
{
Id = Convert.ToInt32(adrow["id"]),
Table = adrow["Table"].ToString(),
Column = adrow["Column"].ToString(),
Value = adrow["Value"].ToString(),
RefrenceId = adrow["Refrenceid"].ToString()
}).Where(w => w.RefrenceId == (row["id"].ToString() + row["SubId"].ToString())).ToList()
: null
}).ToList();
}
return(accountings);
}
