public string AddTeamMaintenance(TeamMaintenance teamMaintenance)
{
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_Team_Maintenance"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
con.Open();
var teamCodeparam = new SqlParameter("@teamCode", teamMaintenance.TeamCode);
var teamDescriptionParam = new SqlParameter("@teamDescription", teamMaintenance.TeamName);
var ctrlCountParam = new SqlParameter("@ctrlCount", teamMaintenance.CtrlCnt);
var reportsParam = new SqlParameter("@reports", teamMaintenance.Reports);
var regionsParam = new SqlParameter("@regions", teamMaintenance.Region);
var subsegmentsParam = new SqlParameter("@subsegments", teamMaintenance.Subsegment);
var modifiedUserParam = new SqlParameter("@modifiedUser", teamMaintenance.ModifiedUser);
cmd.Parameters.Add(teamCodeparam);
cmd.Parameters.Add(teamDescriptionParam);
cmd.Parameters.Add(ctrlCountParam);
cmd.Parameters.Add(reportsParam);
cmd.Parameters.Add(regionsParam);
cmd.Parameters.Add(subsegmentsParam);
cmd.Parameters.Add(modifiedUserParam);
result = Convert.ToString(cmd.ExecuteScalar());
con.Close();
}
}
return(result);
}
public bool EditTeamMaintenance(TeamMaintenance teamMaintenance)
{
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_Team_Maintenance"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
con.Open();
var teamIdparam = new SqlParameter("@teamId", teamMaintenance.TeamMaintenanceID);
var columnParam = new SqlParameter("@column", teamMaintenance.Column);
var valueParam = new SqlParameter("@value", teamMaintenance.Value);
cmd.Parameters.Add(teamIdparam);
cmd.Parameters.Add(columnParam);
cmd.Parameters.Add(valueParam);
int result = cmd.ExecuteNonQuery();
output = true;
con.Close();
}
}
return(output);
}
public async Task <ActionResult> EditTeamMaintenance(TeamMaintenance teamMaintenance)
{
try
{
if (ModelState.IsValid)
{
var myContent = JsonConvert.SerializeObject(teamMaintenance);
HttpResponseMessage response = _objHttpCl.PostAsync(_objHttpCl.BaseAddress + "/Security/EditTeamMaintenance", new StringContent(myContent, UnicodeEncoding.UTF8, "application/json")).Result;
if (response.IsSuccessStatusCode)
{
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 List <TeamMaintenance> GetTeamMaintenanceData()
{
List <TeamMaintenance> output = new List <TeamMaintenance>();
var conn = @"Server=USHYDYMANIDEE12;Database=Aetna;Integrated Security=SSPI;";
using (var con = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand("sp_Team_Maintenance"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TeamMaintenance tmObj = new TeamMaintenance();
tmObj.TeamMaintenanceID = Convert.ToInt32(reader["TeamMaintenanceID"]);
tmObj.TeamCode = Convert.ToString(reader["TeamCode"]);
tmObj.TeamName = Convert.ToString(reader["TeamName"]);
tmObj.CtrlCnt = Convert.ToInt32(reader["CtrlCnt"]);
tmObj.Reports = Convert.ToString(reader["Reports"]);
tmObj.Region = Convert.ToString(reader["Region"]);
tmObj.Subsegment = Convert.ToString(reader["Subsegment"]);
tmObj.ReportIds = Convert.ToString(reader["ReportIds"]);
tmObj.RegionIds = Convert.ToString(reader["RegionIds"]);
tmObj.SubsegmentIds = Convert.ToString(reader["SubsegmentIds"]);
output.Add(tmObj);
}
reader.NextResult();
con.Close();
}
}
return(output);
}
public bool EditTeamMaintenance(TeamMaintenance teamMaintenance)
{
var repository = new DataAccess();
var output = repository.EditTeamMaintenanceNew(teamMaintenance);
return(output);
}
public string AddTeamMaintenance(TeamMaintenance teamMaintenance)
{
var repository = new DataAccess();
var output = repository.AddTeamMaintenance(teamMaintenance);
return(output);
}
public async Task <ActionResult> CreateTeamMaintenance([Bind(Exclude = "TeamMaintenanceID")] TeamMaintenance teamMaintenance)
{
try
{
if (ModelState.IsValid)
{
string oper = Request.Form["oper"];
if (oper == "edit")
{
teamMaintenance.TeamMaintenanceID = Convert.ToInt32(Request.Form["TeamMaintenanceID"]);
return(await EditTeamMaintenance(teamMaintenance));
}
//UserProfile user = (UserProfile)Session["userProfile"];
//teamMaintenance.ModifiedUser = user == null ? "System" : user.aetnaId;
var myContent = JsonConvert.SerializeObject(teamMaintenance);
HttpResponseMessage response = _objHttpCl.PostAsync(_objHttpCl.BaseAddress + "/Security/AddTeamMaintenance", 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));
}
}
public bool EditTeamMaintenanceNew(TeamMaintenance teamMaintenance)
{
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_Team_Maintenance_New"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
con.Open();
var teamIdparam = new SqlParameter("@teamId", teamMaintenance.TeamMaintenanceID);
var teamCodeParam = new SqlParameter("@teamCode", teamMaintenance.TeamCode);
var teamNameParam = new SqlParameter("@teamName", teamMaintenance.TeamName);
var ctrlCountParam = new SqlParameter("@ctrlCount", teamMaintenance.CtrlCnt);
var reportsParam = new SqlParameter("@reports", teamMaintenance.Reports);
var regionsParam = new SqlParameter("@regions", teamMaintenance.Region);
var subsegmentsParam = new SqlParameter("@subsegments", teamMaintenance.Subsegment);
cmd.Parameters.Add(teamIdparam);
cmd.Parameters.Add(teamCodeParam);
cmd.Parameters.Add(teamNameParam);
cmd.Parameters.Add(ctrlCountParam);
cmd.Parameters.Add(reportsParam);
cmd.Parameters.Add(regionsParam);
cmd.Parameters.Add(subsegmentsParam);
int result = cmd.ExecuteNonQuery();
output = true;
con.Close();
}
}
return(output);
}
public async Task <ActionResult> EditCellTeamMaintenance(TeamMaintenanceEdit teamMaintenance)
{
try
{
var tm = new TeamMaintenance();
tm.TeamMaintenanceID = teamMaintenance.TeamMaintenanceID;
if (ModelState.IsValid)
{
if (teamMaintenance.TeamCode != null)
{
tm.Column = "TeamCode";
tm.Value = teamMaintenance.TeamCode;
}
else if (teamMaintenance.TeamName != null)
{
tm.Column = "TeamName";
tm.Value = teamMaintenance.TeamName;
}
else if (teamMaintenance.CtrlCnt != null)
{
tm.Column = "CtrlCnt";
tm.Value = teamMaintenance.CtrlCnt;
}
else if (teamMaintenance.Region != null)
{
tm.Column = "Region";
tm.Value = string.Join(",", teamMaintenance.Region);
}
else if (teamMaintenance.Reports != null)
{
tm.Column = "Reports";
tm.Value = string.Join(",", teamMaintenance.Reports);
}
else if (teamMaintenance.Subsegment != null)
{
tm.Column = "Subsegment";
tm.Value = string.Join(",", teamMaintenance.Subsegment);
}
var myContent = JsonConvert.SerializeObject(tm);
HttpResponseMessage response = _objHttpCl.PostAsync(_objHttpCl.BaseAddress + "/Security/EditTeamMaintenance", new StringContent(myContent, UnicodeEncoding.UTF8, "application/json")).Result;
if (response.IsSuccessStatusCode)
{
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));
}
}
