public TemporaryCrewViewModel GetAllTemporaryCrews()
{
TemporaryCrewViewModel tcVM = new TemporaryCrewViewModel();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetTempCrewAndExistingCrew", con))
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
List <UserMasterPOCO> tcList = new List <UserMasterPOCO>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
UserMasterPOCO tc = new UserMasterPOCO();
tc.UserId = Convert.ToInt32(dr["ID"]);
tc.UserName = Convert.ToString(dr["CrewName"]);
tc.RankName = Convert.ToString(dr["RankName"]);
tc.Email = Convert.ToString(dr["Email"]);
tc.ShipId = Convert.ToInt32(dr["ShipId"]);
var histRows = ds.Tables[1].Rows
.Cast <DataRow>()
.Where(x => x.Field <string>(3) == tc.RankName && x.Field <int>(4) == tc.ShipId).ToList();
List <UserMasterPOCO> replaceableUserList = new List <UserMasterPOCO>();
UserMasterPOCO initial = new UserMasterPOCO();
initial.UserId = 0;
initial.UserName = "******";
replaceableUserList.Add(initial);
foreach (DataRow drh in histRows)
{
UserMasterPOCO replaceableUser = new UserMasterPOCO();
replaceableUser.UserId = Convert.ToInt32(drh["UserId"]);
replaceableUser.UserName = Convert.ToString(drh["UserName"]) + "(" + Convert.ToString(drh["UserCode"]) + ")";
replaceableUser.UserCode = Convert.ToString(drh["UserCode"]);
replaceableUserList.Add(replaceableUser);
}
tc.ReplaceableCrews = replaceableUserList;
tcList.Add(tc);
}
tcVM.TemporaryCrewList = tcList;
}
}
return(tcVM);
}
public ActionResult ImportCrew()
{
ImportBL imBl = new ImportBL();
TemporaryCrewViewModel crewImportVM = new TemporaryCrewViewModel();
if (Session["Role"].ToString() == "SupportUser" || Session["Role"].ToString() == "ShipAdmin")
{
crewImportVM = imBl.GetAllTemporaryCrews();
return(View(crewImportVM));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
