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