public List <CustCompanyVM> GetCompanies(int leadId)
{
List <CustCompanyVM> lstCompanies = new List <CustCompanyVM>();
string cnnString = System.Configuration.ConfigurationManager.ConnectionStrings["ChemAnalystContext"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_GetCompanies";
//add any parameters the stored procedure might require
cmd.Parameters.Add(new SqlParameter("@LeadId", leadId));
cnn.Open();
//object o = cmd.ExecuteScalar();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
CustCompanyVM objCom = new CustCompanyVM();
objCom.id = Convert.ToInt32(rdr["id"]);
objCom.Name = rdr["Name"] != null ? rdr["Name"].ToString() : "N/A";
objCom.EmailId = rdr["EmailId"] != null ? rdr["EmailId"].ToString() : "N/A";
objCom.Address = rdr["Address"] != null ? rdr["Address"].ToString() : "N/A";
objCom.Description = rdr["Description"] != null ? rdr["Description"].ToString() : "N/A";
objCom.Logo = rdr["Logo"] != null ? rdr["Logo"].ToString() : "N/A";
objCom.RegDate = rdr["RegDate"] != null?Convert.ToDateTime(rdr["RegDate"]).ToString("dd/MM/yyyy") : "N/A";
objCom.CIN = rdr["CIN"] != null ? rdr["CIN"].ToString() : "N/A";
objCom.Category = rdr["Category"] != null ? rdr["Category"].ToString() : "N/A";
objCom.NOE = rdr["NOE"] != null ? rdr["NOE"].ToString() : "N/A";
objCom.CEO = rdr["CEO"] != null ? rdr["CEO"].ToString() : "N/A";
objCom.website = rdr["website"] != null ? rdr["website"].ToString() : "N/A";
objCom.phoneNo = rdr["phoneNo"] != null ? rdr["phoneNo"].ToString() : "N/A";
objCom.fax = rdr["fax"] != null ? rdr["fax"].ToString() : "N/A";
lstCompanies.Add(objCom);
}
}
cnn.Close();
return(lstCompanies);
}
public ActionResult CompanyProfileDetails(int id)
{
ChemAnalystContext db = new ChemAnalystContext();
CompanyDataStore obj = new CompanyDataStore();
CustCompanyVM model = new CustCompanyVM();
var data = obj.GetCompanyByid(id);
model.Name = data.Name;
model.Description = data.Description;
model.Logo = data.Logo;
model.EmailId = data.EmailId;
model.Address = data.Address;
model.phoneNo = data.phoneNo;
model.fax = data.fax;
model.website = data.website;
model.RegDate = data.RegDate.Date.ToString("dd/MM/yyyy");
model.CreatedTime = data.RegDate.Date.Year.ToString();
model.NOE = data.NOE;
model.CEO = data.CEO;
model.CIN = data.CIN;
model.Category = data.Category;
model.id = data.id;
model.Meta = data.Meta;
model.MetaDescription = data.MetaDescription;
model.lstFinacialData = db.CompanyProfRecordNew.Where(w => w.SA_CompanyId == data.id).Select(x => new CompanyFinacialData
{
//FinacialYear = db.FinancialYears.Where(f => f.Id == x.FinancialYearId).FirstOrDefault().FinYear,
FinacialYear = x.year,
Growth = x.Growth,
Revenue = x.Revenue,
PBT = x.PBT,
Liablities = x.Liablities,
Margin = x.Margin,
Margin1 = x.Margin1,
Pat = x.Pat
}).ToList();
ViewBag.S = obj.GetSWOTByCompany(id);
return(View(model));
}
