public string HandleConfigTarget()
{
string re = "";
var connectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
var targetConfig = new RepDayOffDAL(connectionString);
var listConfig = targetConfig.GetAllTargetItems();
var currentDay = DateTime.Now.Date;
listConfig = (from cons in listConfig where cons.TargetDay.Date == currentDay
select cons).ToList();
if (listConfig.Count() > 0)
{
getRepName();
re = listConfig[0].TargetTitle + "," + Math.Truncate(listConfig[0].TargetAmount);
}
float dailyVolume = 0.0f;
foreach (var pair in di_getStat)
{
obj_Contact = (DelReport_Contact)pair.Value;
String repName = obj_Contact.FirstName + " " + obj_Contact.LastName;
dailyVolume = dailyVolume + getDailyVolume(repName);
}
if (!string.IsNullOrEmpty(re))
{
re = re + "," + dailyVolume + "," + listConfig[0].Id + "," + listConfig[0].IsReached;
}
return(re);
}
public void getRepName()
{
DelReport_Contact obj_contact;
List <string> RepsName = new List <string>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = @"SELECT LoginID, FirstName, LastName,Department,Commission , DonotShowOnStats FROM dbo.Logins
WHERE LoginID IN (1,2,10,15,17,35,41,42,43,44,45) AND Active = 'Y' ";
cmd.Connection = conn;
conn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
var comme = 0;
if (sdr["Commission"] != DBNull.Value)
{
comme = Convert.ToInt32(sdr["Commission"].ToString());
if (comme > 0)
{
{
RepsName.Add(sdr["FirstName"].ToString() + ' ' + sdr["LastName"].ToString());
obj_contact = new DelReport_Contact();
obj_contact.DepartmentId = "3";// null avoid
obj_contact.FirstName = sdr["FirstName"].ToString();
obj_contact.LastName = sdr["LastName"].ToString();
obj_contact.LoginId = Convert.ToInt32(sdr["LoginID"].ToString());
if (sdr["Department"] != DBNull.Value)
{
obj_contact.DepartmentId = sdr["Department"].ToString();
}
di_getStat.Add(sdr["LoginID"].ToString(), obj_contact);
}
}
}
}
}
}
conn.Close();
}
}
}
