protected void gridViewStageMapping_Command(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
GetMyAccessRights();
modalBtnDelete.Visible = myAccessRights.CanDelete == null ? false : Convert.ToBoolean(myAccessRights.CanDelete);
modalLabelError.Text = "";
modalLabelError.Visible = false;
int index = Convert.ToInt32(e.CommandArgument);
int stageMappingId = Convert.ToInt32(((Label)gridViewStageMapping.Rows[index].FindControl("labelStageMappingId")).Text);
modalLabelStageMappingId.Text = stageMappingId.ToString();
CAPStageMapping capStageMapping = new CAPStageMapping();
capStageMapping = capStageMapping.GetCapStageMapping(stageMappingId);
InitializeModalDropDownDepartment(capStageMapping.DepartmentId.ToString());
InitializeModalDropDownJobType(Convert.ToInt32(modalDropDownDepartment.SelectedItem.Value),capStageMapping.JobTypeId.ToString().Trim());
InitializeModalDatabase(capStageMapping.DatabaseMap.Trim());
InitializeModalCAPStages(modalDropDownDatabase.SelectedItem.Value.Trim(),capStageMapping.SD_Stage_No.ToString().Trim());
modalBtnSubmit.Visible = Convert.ToBoolean(myAccessRights.CanUpdate);
modalBtnSubmit.CommandArgument = "Update";
programmaticModalPopup.Show();
}
}
protected void InitializeModalCAPStages(string databasemap,string selectedStage = "")
{
CAPStageMapping capstagemapping = new CAPStageMapping();
List<CAPStageMapping> capStageList = new List<CAPStageMapping>();
capStageList = capstagemapping.GetCAPStagesByCAPDatabase(databasemap);
modalDropDownCapStage.DataSource = capStageList;
modalDropDownCapStage.DataTextField = "StageDescription";
modalDropDownCapStage.DataValueField = "SD_Stage_No";
modalDropDownCapStage.DataBind();
if (selectedStage != null && selectedStage.Trim() != "")
{
foreach (ListItem i in modalDropDownCapStage.Items)
{
if (i.Value.Trim() == selectedStage.Trim())
{
i.Selected = true;
break;
}
}
}
}
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e)
{
CAPStageMapping capstageMapping = new CAPStageMapping();
bool haserror = false;
if (e.CommandArgument.ToString().Trim() == "Add")
{
capstageMapping = capstageMapping.GetCapStageMapping(capstageMapping.DepartmentId, capstageMapping.JobTypeId);
if (capstageMapping != null)
{
modalLabelError.Text = "Error: JobType already been map.";
modalLabelError.Visible = true;
haserror = true;
}
capstageMapping = new CAPStageMapping();
}
else
{
int mappingId = Convert.ToInt32(modalLabelStageMappingId.Text);
capstageMapping = capstageMapping.GetCapStageMapping(capstageMapping.DepartmentId, capstageMapping.JobTypeId);
if (capstageMapping != null && capstageMapping.Id != mappingId)
{
modalLabelError.Text = "Error: JobType already been map.";
modalLabelError.Visible = true;
haserror = true;
}
capstageMapping = new CAPStageMapping();
capstageMapping.Id = mappingId;
}
if (haserror)
{
this.programmaticModalPopup.Show();
}
else
{
capstageMapping.DepartmentId = Convert.ToInt32(modalDropDownDepartment.SelectedItem.Value);
capstageMapping.JobTypeId = Convert.ToInt32(modalDropDownJobType.SelectedItem.Value);
capstageMapping.DatabaseMap = modalDropDownDatabase.SelectedItem.Value.Trim();
capstageMapping.SD_Stage_No = Convert.ToInt32(modalDropDownCapStage.SelectedItem.Value);
capstageMapping.StageDescription = modalDropDownCapStage.SelectedItem.Text.Trim();
if (e.CommandArgument.ToString().Trim() == "Add")
{
capstageMapping.Insert(capstageMapping);
}
else
{
capstageMapping.Update(capstageMapping);
}
modalLabelError.Text = "";
modalLabelError.Visible = false;
this.programmaticModalPopup.Hide();
InitializeMainGrid();
}
}
private void InitializeMainGrid()
{
GetMyAccessRights();
CAPStageMapping capStageMapping = new CAPStageMapping();
if (myAccessRights.CanAdd == true)
{
linkBtnAdd.Visible = true;
}
else
linkBtnAdd.Visible = false;
List<CAPStageMapping> stagemappings = new List<CAPStageMapping>();
if (dropDownListDepartment.SelectedItem.Text == "All")
{
stagemappings = capStageMapping.GetCapStageMappingList();
}
else
{
stagemappings = capStageMapping.GetCapStageMappingListByDepartment(Convert.ToInt32(dropDownListDepartment.SelectedItem.Value));
}
gridViewStageMapping.DataSource = stagemappings;
gridViewStageMapping.DataBind();
}
protected void modalBtnDelete_Command(object sender, CommandEventArgs e)
{
CAPStageMapping capStageMapping = new CAPStageMapping();
int mappingId = Convert.ToInt32(modalLabelStageMappingId.Text);
capStageMapping.Delete(mappingId);
this.programmaticModalPopup.Hide();
InitializeMainGrid();
}
private void ParseMapping(T_CAPStageMapping t_capstagemapping, CAPStageMapping capstagemapping)
{
t_capstagemapping.Id = capstagemapping.Id;
t_capstagemapping.DepartmentId = capstagemapping.DepartmentId;
t_capstagemapping.JobTypeId = capstagemapping.JobTypeId;
t_capstagemapping.SD_Stage_No = capstagemapping.SD_Stage_No;
t_capstagemapping.DatabaseMap = capstagemapping.DatabaseMap;
t_capstagemapping.StageDescription = capstagemapping.StageDescription;
}
public void Update(CAPStageMapping capstagemapping)
{
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
T_CAPStageMapping t_capstagemapping = db.T_CAPStageMapping.FirstOrDefault(p => p.Id == capstagemapping.Id);
ParseMapping(t_capstagemapping, capstagemapping);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
public void Insert(CAPStageMapping capstagemapping)
{
T_CAPStageMapping t_capstagemapping = new T_CAPStageMapping();
ParseMapping(t_capstagemapping, capstagemapping);
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
db.T_CAPStageMapping.Add(t_capstagemapping);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
public List<CAPStageMapping> GetCAPStagesByCAPDatabase(string databaselocation)
{
//Gets all stages from STAGE_DEFINITION table in CAP by databaselocation
//databaselocation is set in WebConfig. (CAPHWConnection or CAPSWConnection)
List<CAPStageMapping> capStageList = new List<CAPStageMapping>();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[databaselocation].ToString()))
{
SqlCommand cmd = new SqlCommand("Select SD_Stage_No,SD_Stage_Desc from STAGE_DEFINITION ", con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CAPStageMapping capStage = new CAPStageMapping();
capStage.SD_Stage_No = Convert.ToInt32(reader["SD_Stage_No"].ToString());
capStage.StageDescription = reader["SD_Stage_Desc"].ToString();
capStage.DatabaseMap = databaselocation;
capStageList.Add(capStage);
}
}
return capStageList;
}