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