public string AddUserTeamMapping(UserTeamMapping userTeamMapping)
{
string result = "";
var conn = @"Server=USHYDYMANIDEE12;Database=Aetna;Integrated Security=SSPI;";
using (var con = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand("sp_SEC_Add_User_Team_Mapping"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
con.Open();
var userIdParam = new SqlParameter("@userId", userTeamMapping.USER_ID);
var firstNameParam = new SqlParameter("@firstName", userTeamMapping.FIRST_NAM);
var lastNameParam = new SqlParameter("@LastName", userTeamMapping.LAST_NAM);
var employeeStatusParam = new SqlParameter("@employeeStatus", userTeamMapping.EMP_STS_CD);
var teamsParam = new SqlParameter("@teams", userTeamMapping.TEAMS);
var modifiedUserParam = new SqlParameter("@modifiedUser", userTeamMapping.ModifiedUser);
cmd.Parameters.Add(userIdParam);
cmd.Parameters.Add(firstNameParam);
cmd.Parameters.Add(lastNameParam);
cmd.Parameters.Add(employeeStatusParam);
cmd.Parameters.Add(teamsParam);
cmd.Parameters.Add(modifiedUserParam);
result = Convert.ToString(cmd.ExecuteScalar());
con.Close();
}
}
return(result);
}
public bool EditUserTeamMapping(UserTeamMapping userTeamMapping)
{
var output = false;
var conn = @"Server=USHYDYMANIDEE12;Database=Aetna;Integrated Security=SSPI;";
using (var con = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand("sp_SEC_Edit_User_Team_Mapping"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
con.Open();
var userIdParam = new SqlParameter("@userId", userTeamMapping.USER_ID);
var columnParam = new SqlParameter("@column", userTeamMapping.Column);
var valueParam = new SqlParameter("@value", userTeamMapping.Value);
cmd.Parameters.Add(userIdParam);
cmd.Parameters.Add(columnParam);
cmd.Parameters.Add(valueParam);
int result = cmd.ExecuteNonQuery();
output = true;
con.Close();
}
}
return(output);
}
public List <UserTeamMapping> GetUserTeamMappingData()
{
List <UserTeamMapping> output = new List <UserTeamMapping>();
var conn = @"Server=USHYDYMANIDEE12;Database=Aetna;Integrated Security=SSPI;";
using (var con = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand("sp_User_Team_Mapping"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
UserTeamMapping utmObj = new UserTeamMapping();
utmObj.USER_ID = Convert.ToString(reader["USER_ID"]);
utmObj.FIRST_NAM = Convert.ToString(reader["FIRST_NAM"]);
utmObj.LAST_NAM = Convert.ToString(reader["LAST_NAM"]);
utmObj.EMP_STS_CD = Convert.ToString(reader["EMP_STS_CD"]);
utmObj.TEAMS = Convert.ToString(reader["TEAMS"]);
output.Add(utmObj);
}
reader.NextResult();
con.Close();
}
}
return(output);
}
public bool EditUserTeamMapping(UserTeamMapping userTeamMapping)
{
var repository = new DataAccess();
var output = repository.EditUserTeamMapping(userTeamMapping);
return(output);
}
public string AddUserTeamMapping(UserTeamMapping userTeamMapping)
{
var repository = new DataAccess();
var output = repository.AddUserTeamMapping(userTeamMapping);
return(output);
}
public async Task <ActionResult> EditCellUserTeamMapping(UserTeamMappingEdit userTeamMapping)
{
try
{
var utm = new UserTeamMapping();
utm.USER_ID = userTeamMapping.USER_ID;
if (ModelState.IsValid)
{
if (userTeamMapping.FIRST_NAM != null)
{
utm.Column = "FIRST_NAM";
utm.Value = userTeamMapping.FIRST_NAM;
}
else if (userTeamMapping.LAST_NAM != null)
{
utm.Column = "LAST_NAM";
utm.Value = userTeamMapping.LAST_NAM;
}
else if (userTeamMapping.EMP_STS_CD != null)
{
utm.Column = "EMP_STS_CD";
utm.Value = userTeamMapping.EMP_STS_CD;
}
else if (userTeamMapping.TEAMS != null)
{
utm.Column = "TEAMS";
utm.Value = string.Join(",", userTeamMapping.TEAMS);
}
var myContent = JsonConvert.SerializeObject(utm);
HttpResponseMessage response = _objHttpCl.PostAsync(_objHttpCl.BaseAddress + "/Security/EditUserTeamMapping", new StringContent(myContent, UnicodeEncoding.UTF8, "application/json")).Result;
if (response.IsSuccessStatusCode)
{
var output = await response.Content.ReadAsStringAsync();
return(Json("Saved Successfully!", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("An Error Occured!", JsonRequestBehavior.AllowGet));
}
}
else
{
var errorList = (from item in ModelState
where item.Value.Errors.Any()
select item.Value.Errors[0].ErrorMessage).ToList();
return(Json(errorList, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
var errormessage = "Error occured: " + ex.Message;
return(Json(errormessage, JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> CreateUserTeamMapping(UserTeamMapping userTeamMapping)
{
try
{
if (ModelState.IsValid)
{
//UserProfile user = (UserProfile)Session["userProfile"];
//userTeamMapping.ModifiedUser = user == null ? "System" : user.aetnaId;
var myContent = JsonConvert.SerializeObject(userTeamMapping);
HttpResponseMessage response = _objHttpCl.PostAsync(_objHttpCl.BaseAddress + "/Security/AddUserTeamMapping", new StringContent(myContent, UnicodeEncoding.UTF8, "application/json")).Result;
if (response.IsSuccessStatusCode)
{
var output = await response.Content.ReadAsStringAsync();
return(Json(output, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("An Error Occured!", JsonRequestBehavior.AllowGet));
}
}
else
{
var errorList = (from item in ModelState
where item.Value.Errors.Any()
select item.Value.Errors[0].ErrorMessage).ToList();
return(Json(errorList, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
var errormessage = "Error occured: " + ex.Message;
return(Json(errormessage, JsonRequestBehavior.AllowGet));
}
}
