public CompanyLead GetCompanyLeadByCompanyId(int comID)
{
var listCom = new CompanyLead();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = CONNSTRING;
String strSqlContactStmt = @"SELECT UserId,CompanyId,CreatedDate,ExpiryDate FROM dbo.LeadCompany where CompanyId=" + comID;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = strSqlContactStmt;
cmd.Connection = conn;
conn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
var comLea = new CompanyLead();
comLea.UserId = Convert.ToInt32(sdr["UserId"].ToString());
comLea.CompanyId = Convert.ToInt32(sdr["CompanyId"].ToString());
comLea.CreatedDate = Convert.ToDateTime(sdr["CreatedDate"].ToString());
comLea.ExpiryDate = Convert.ToDateTime(sdr["ExpiryDate"].ToString());
// if (comLea.ExpiryDate.Date )
return(comLea);
}
}
}
}
conn.Close();
return(null);
}
public List <CompanyLead> GetLeadCompaniesNotExist()
{
var listCom = new List <CompanyLead>();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = CONNSTRING;
String strSqlContactStmt = @"SELECT UserId,CompanyId,CreatedDate,ExpiryDate FROM dbo.LeadCompanyNotExists ";
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = strSqlContactStmt;
cmd.Connection = conn;
conn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
var comLea = new CompanyLead();
comLea.UserId = Convert.ToInt32(sdr["UserId"].ToString());
comLea.CompanyId = Convert.ToInt32(sdr["CompanyId"].ToString());
comLea.CreatedDate = Convert.ToDateTime(sdr["CreatedDate"].ToString());
comLea.ExpiryDate = Convert.ToDateTime(sdr["ExpiryDate"].ToString());
listCom.Add(comLea);
}
}
}
}
conn.Close();
return(listCom);
}
