private IList <RepDetail> GetReps() { List <RepDetail> RepsName = new List <RepDetail>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = @"SELECT LoginID, FirstName, LastName,Department,Commission FROM dbo.Logins WHERE LoginID NOT IN (1,4, 9,18, 8,7, 19,20,21,22,14) 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()); var obj = new RepDetail(); obj.RepId = sdr["LoginID"].ToString(); obj.RepName = sdr["FirstName"].ToString(); // obj_contact.LastName = sdr["LastName"].ToString(); RepsName.Add(obj); //if (sdr["Department"] != DBNull.Value) // obj_contact.DepartmentId = sdr["Department"].ToString(); //di_getStat.Add(sdr["LoginID"].ToString(), obj_contact); } } } } } conn.Close(); } } return(RepsName); }
public ActionResult Edit(int id, RepDetail model) { if (!ModelState.IsValid) { return(View(model)); } if (model.ID != id) { ModelState.AddModelError("", "Id Mismatch"); return(View(model)); } var service = new RepService(); if (service.UpdateRep(model)) { TempData["SaveResult"] = "Rep Details Successfully Updated"; return(RedirectToAction("Index")); } ModelState.AddModelError("", "Failed to Update Rep"); return(View(model)); }