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