public ActionResult Authorize(BI_USER userModel)
{
if (!ModelState.IsValid)
{
return(View(userModel));
}
using (TKTDSXEntities db = new TKTDSXEntities())
{
string strInput = userModel.Password.Trim();
string decryptPass = CryptorEngine.Encrypt(strInput, true);
var userDetails = db.BI_USER.Where(x => x.MANDT == "900" && x.SYSID == "P01" &&
x.Username == userModel.Username && x.Password == decryptPass).FirstOrDefault();
if (userDetails == null)
{
ModelState.AddModelError("", "Sign failed, please check input again.");
return(View("Index", userModel));
}
else
{
Session["Username"] = userDetails;
return(RedirectToAction("Index", "Liveboard"));
}
}
}
public ActionResult Login(ZEMP_USER account)
{
if (!ModelState.IsValid)
{
return(View(account));
}
using (TKTDSXEntities db = new TKTDSXEntities())
{
string strInput = account.Password.Trim();
string decryptPass = CryptorEngine.Encrypt(strInput, true);
var userDetails = db.ZEMP_USER.Where(x => x.SystemId == CommonHeader.defaultSystemId &&
x.Username == account.Username && x.Password == decryptPass).FirstOrDefault();
if (userDetails == null)
{
ModelState.AddModelError("", "Sign failed, please check input again.");
return(View("Index", account));
}
else
{
Session[CommonHeader.ctlAccount] = userDetails;
return(RedirectToAction("Index", "Liveboard"));
}
}
}
public List <SelectListItem> GetListCongDoan(string sSystemId, string sLastCongDoan)
{
List <SelectListItem> listCongDoan = new List <SelectListItem>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
try
{
var listRaw = dc.GetCongDoanLiveboard(sSystemId).ToList <SelectListReturn>();
bool isSelect = false;
if (sLastCongDoan == null)
{
listCongDoan.Add(new SelectListItem()
{
Text = CommonHeader.CongDoanAllText, Value = CommonHeader.CongDoanAllValue, Selected = true
});
}
else
{
listCongDoan.Add(new SelectListItem()
{
Text = CommonHeader.CongDoanAllText, Value = CommonHeader.CongDoanAllValue, Selected = false
});
}
for (int i = 0; i < listRaw.Count; i++)
{
if (listRaw[i].value == sLastCongDoan)
{
isSelect = true;
}
else
{
isSelect = false;
}
listCongDoan.Add(new SelectListItem()
{
Text = listRaw[i].text, Value = listRaw[i].value, Selected = isSelect
});
}
}
catch (Exception ex)
{
ZEMP_LOG zlog = new ZEMP_LOG()
{
Ngay = DateTime.Now,
LogKey = "GetCongDoanLiveboard",
LogDescription = string.Format("Exeption Msg: {0} ,SystemId: {1}", ex.Message, sSystemId)
};
dc.ZEMP_LOG.Add(zlog);
dc.SaveChanges();
}
}
return(listCongDoan);
}
public List <SelectListItem> GetListCapDoByUsername(ZEMP_USER account)
{
bool isSelect = false;
List <SelectListItem> selectList = new List <SelectListItem>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
try
{
var listRaw = dc.GetListCapDo(account.SystemId, account.Username).ToList <SelectListReturn>();
for (int i = 0; i < listRaw.Count; i++)
{
if (account.LastCapDo != "")
{
if (listRaw[i].value == account.LastCapDo)
{
isSelect = true;
}
else
{
isSelect = false;
}
}
else
{
if (i == 0)
{
isSelect = true;
}
else
{
isSelect = false;
}
}
selectList.Add(new SelectListItem()
{
Text = listRaw[i].text, Value = listRaw[i].value, Selected = isSelect
});
}
}
catch (Exception ex)
{
ZEMP_LOG zlog = new ZEMP_LOG()
{
Ngay = DateTime.Now,
LogKey = "GetListCapDoByUsername",
LogDescription = string.Format("Exeption Msg: {0} , Username: {1} , LastCapDo: {2}",
ex.Message, account.Username, account.LastCapDo)
};
dc.ZEMP_LOG.Add(zlog);
dc.SaveChanges();
}
}
return(selectList);
}
public List <SelectListItem> GetModeView(ZEMP_USER account)
{
List <SelectListItem> listMode = new List <SelectListItem>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
try
{
var listRaw = dc.GetModeView(account.SystemId).ToList <SelectListReturn>();
bool isSelect = false;
for (int i = 0; i < listRaw.Count; i++)
{
isSelect = false;
if (account.LastMode == null)
{
if (i == 0)
{
isSelect = true;
}
else
{
isSelect = false;
}
}
else
{
if (account.LastMode == listRaw[i].value)
{
isSelect = true;
}
else
{
isSelect = false;
}
}
listMode.Add(new SelectListItem()
{
Value = listRaw[i].value, Text = listRaw[i].text, Selected = isSelect
});
}
}
catch (Exception ex)
{
ZEMP_LOG zlog = new ZEMP_LOG()
{
Ngay = DateTime.Now,
LogKey = "GetModeView",
LogDescription = string.Format("Exeption Msg: {0} ,SystemId: {1}", ex.Message, account.SystemId)
};
dc.ZEMP_LOG.Add(zlog);
dc.SaveChanges();
}
}
return(listMode);
}
private List<ListCongDoan> getCongDoanKeHoachThucHien(FilterCondition f)
{
List<ListCongDoan> listCd = new List<ListCongDoan>();
using(TKTDSXEntities dc = new TKTDSXEntities() )
{
listCd = dc.GetCongDoanKhTh(f.SystemId, f.SelectedCapDo, f.SelectedGiaTriCapDo,
f.SelectedCongDoan, f.sDateFrom, f.sDateTo).ToList<ListCongDoan>();
}
return listCd;
}
public string GetPhanQuyen(ref FilterCondition filter, ZEMP_USER account)
{
string strResult = CommonHeader.ResultOK;
AccountDTO accDto = new AccountDTO();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
filter.ListCapDo = accDto.GetListCapDoByUsername(account);
foreach (var item in filter.ListCapDo)
{
if (item.Selected)
{
filter.SelectedCapDo = item.Value;
break;
}
}
if (filter.ListCapDo.Count() == 0)
{
strResult = "Chưa được phân quyền";
}
//Get list gia tri cap do theo selected cap do
filter.ListGiaTriCapDo = accDto.GetListGiaTriCapDo(account, filter.SelectedCapDo);
foreach (var item in filter.ListGiaTriCapDo)
{
if (item.Selected)
{
filter.SelectedGiaTriCapDo = item.Value;
break;
}
}
LiveboardDTO liveboard = new LiveboardDTO();
//Get list cong doan
filter.ListCongDoan = liveboard.GetListCongDoan(account.SystemId, account.LastCongDoan);
foreach (var item in filter.ListCongDoan)
{
if (item.Selected)
{
filter.SelectedCongDoan = item.Value;
}
}
filter.ListModeView = liveboard.GetModeView(account);
foreach (var item in filter.ListModeView)
{
if (item.Selected)
{
filter.SelectedMode = item.Value;
}
}
return(strResult);
}
}
// GET: Liveboard
public ActionResult Index([Bind(Include = "SelectedMode,SelectedCapdo,SelectedGiaTriCapDo,SelectedCongDoan")] FilterCoditionModel FilterCodition)
{
var CurrentUser = Session["Username"] as BI_USER;
if (CurrentUser == null)
{
return(RedirectToAction("Index", "Login"));
}
string strResult = String.Empty;
using (TKTDSXEntities dc = new TKTDSXEntities())
{
CommonModel cm = new CommonModel();
try
{
//get user login
FilterCodition.MANDT = CurrentUser.MANDT;
FilterCodition.SYSID = CurrentUser.SYSID;
//add mode view
//get data of current date
FilterCodition.DateFrom = DateTime.Now;
FilterCodition.DateTo = DateTime.Now;
strResult = cm.GetPhanQuyen(ref FilterCodition, CurrentUser.Username);
ViewBag.SelectedCapDo = FilterCodition.ListCapDo;
ViewBag.SelectedGiaTriCapDo = FilterCodition.ListGiaTriCapDo;
ViewBag.GiatriCapDo = FilterCodition.SelectedGiaTriCapDo;
//lay danh sach cong doan
cm.GetCongDoanAll(ref FilterCodition);
ViewBag.SelectedCongDoan = FilterCodition.ListCongDoan;
cm.getModeView(ref FilterCodition);
ViewBag.SelectedMode = FilterCodition.ListModeView;
return(View("Index", FilterCodition));
}
catch (Exception ex)
{
ViewBag.MessagePQ = "Chưa được cấp quyền" + ex.Message;
return(View());
}
}
}
private List<KHTHReturn> GetKeHoachThucHien(FilterCondition filter)
{
List<KHTHReturn> listKHTH = new List<KHTHReturn>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
listKHTH = dc.GetKeHoachThucHien(filter.SystemId,
filter.SelectedCapDo,
filter.SelectedGiaTriCapDo,
filter.SelectedCongDoan,
filter.sDateFrom,
filter.sDateTo).ToList<KHTHReturn>();
}
return listKHTH;
}
public ArrayList GetKeHoachThucHien(FilterCondition filter)
{
ArrayList listKhTh = new ArrayList();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
string dtFrom = string.Format("{0}-{1}-{2}", filter.DateFrom.Year, filter.DateFrom.Month, filter.DateFrom.Day);
string dtTo = string.Format("{0}-{1}-{2}", filter.DateFrom.Year, filter.DateFrom.Month, filter.DateFrom.Day);
try
{
var listRaw = dc.GetKeHoachThucHien(filter.SystemId, filter.SelectedCapDo, filter.SelectedGiaTriCapDo,
filter.SelectedCongDoan, dtFrom, dtTo).ToList <KHTHReturn>();
//Header
ArrayList lineHeader = new ArrayList();
lineHeader.Add("Data");
for (int i = 0; i < listRaw.Count; i++)
{
lineHeader.Add(listRaw[i].CONGDOAN.ToString());
}
listKhTh.Add(lineHeader);
//KeHoach
ArrayList lineKeHoach = new ArrayList();
lineKeHoach.Add("KeHoach");
for (int y = 0; y < listRaw.Count; y++)
{
lineKeHoach.Add(listRaw[y].KEHOACH.ToString());
}
listKhTh.Add(lineKeHoach);
//ThucHien
ArrayList lineThucHien = new ArrayList();
lineThucHien.Add("ThucHien");
for (int y = 0; y < listRaw.Count; y++)
{
lineThucHien.Add(listRaw[y].THUCHIEN.ToString());
}
listKhTh.Add(lineThucHien);
}
catch
{
//do nothing
}
}
return(listKhTh);
}
private List<ThongKeLaoDong> GetThongKeLaoDong(FilterCondition f)
{
var listLaoDong = new List<ThongKeLaoDong>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
try
{
listLaoDong = dc.GetThongKeLaoDong(f.SystemId, f.SelectedCapDo,
f.SelectedGiaTriCapDo, f.SelectedCongDoan, f.sDateFrom, f.sDateTo).ToList<ThongKeLaoDong>();
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
return listLaoDong;
}
} //end function - GetThongKeLaoDong
private List<ChiPhiSanXuat> GetChiPhiSanXuat(FilterCondition f)
{
var listChiPhi = new List<ChiPhiSanXuat>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
try
{
listChiPhi = dc.GETCHIPHISANXUAT(f.SystemId,
f.SelectedCapDo, f.SelectedGiaTriCapDo, f.SelectedCongDoan,
f.sDateFrom, f.sDateTo).ToList<ChiPhiSanXuat>();
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
}
return listChiPhi;
}
private List<CountStatus> CountStatusChuyen(FilterCondition f)
{
var listCountStatus = new List<CountStatus>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
try
{
listCountStatus = dc.CountTrangThaiChuyen(f.SystemId, f.SelectedCapDo,
f.SelectedGiaTriCapDo, f.SelectedCongDoan, f.sDateFrom, f.sDateTo).ToList<CountStatus>();
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
}
return listCountStatus;
}
public ActionResult GetListData(string level, string capdo, string giaTriCapdo, string congDoan, string sStyle)
{
FilterCoditionModel filter = new FilterCoditionModel()
{
MANDT = "900",
SYSID = "P01",
SelectedMode = level,
SelectedCapDo = capdo,
SelectedGiaTriCapDo = giaTriCapdo,
SelectedCongDoan = congDoan
};
using (TKTDSXEntities dc = new TKTDSXEntities())
{
var CurrentUser = Session["Username"] as BI_USER;
CommonModel cm = new CommonModel();
//Mode xem
if (filter.SelectedMode == null)
{
filter.SelectedMode = "CHUYEN";
}
List <SanLuongOnline> slOnline = cm.GetSanLuongOnline(filter, CurrentUser.Username);
ViewData["SL_Online"] = slOnline;
}
//asign style for table
switch (sStyle)
{
case "Default":
ViewBag.ClassName = "tablesorter-default";
break;
case "Blue":
ViewBag.ClassName = "tablesorter-blue";
break;
case "Dark":
ViewBag.ClassName = "tablesorter-dark";
break;
}
return(PartialView(filter));
}
public ActionResult GetSub(string CapDoID)
{
TKTDSXEntities dc = new TKTDSXEntities();
var CurrentUser = Session["Username"] as BI_USER;
List <BI_PHAN_QUYEN> listPQ = dc.BI_PHAN_QUYEN.Where(p => p.CapDo == CapDoID && p.Username == CurrentUser.Username).ToList();
List <SelectListItem> items = new List <SelectListItem>();
foreach (BI_PHAN_QUYEN item in listPQ)
{
items.Add(new SelectListItem()
{
Text = item.DGGiaTri, Value = item.GiaTri
});
}
// you may replace the above code with data reading from database based on the id
return(Json(items, JsonRequestBehavior.AllowGet));
}
public List <SanLuongOnline> GetSanLuongOnline(string sModeView, string sCapDo, string sGiaTriCapDo, string sCongDoan, string sNgay)
{
var ListSanLuong = new List <SanLuongOnline>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
List <SanLuongOnlineReturn> listRaw = dc.GetSanLuongOnline(CommonHeader.defaultSystemId, sModeView, sCapDo, sGiaTriCapDo, sCongDoan, sNgay).ToList <SanLuongOnlineReturn>();
foreach (var item in listRaw)
{
var itemSanLuong = new SanLuongOnline()
{
BoPhan = item.BoPhan,
CongDoan = item.TenCongDoan,
SoLuongLaoDong = int.Parse(item.SoLuongLD.ToString()),
NangSuat = double.Parse(item.NangSuat.ToString()),
GioLamViec = double.Parse(item.GioLamViec.ToString()),
KeHoachGio = int.Parse(item.KeHoachGio.ToString()),
KeHoachNgay = int.Parse(item.KeHoachNgay.ToString()),
ThucHien = int.Parse(item.ThucHienNgay.ToString()),
ChenhLech = int.Parse(item.ChenhLech.ToString()),
DatSanLuong = double.Parse(item.DatKeHoach.ToString()),
Truoc8h = int.Parse(item.Truoc8h.ToString()),
Gio08 = int.Parse(item.Gio08.ToString()),
Gio09 = int.Parse(item.Gio09.ToString()),
Gio10 = int.Parse(item.Gio10.ToString()),
Gio11 = int.Parse(item.Gio11.ToString()),
Gio12 = int.Parse(item.Gio12.ToString()),
Gio13 = int.Parse(item.Gio13.ToString()),
Gio14 = int.Parse(item.Gio14.ToString()),
Gio15 = int.Parse(item.Gio15.ToString()),
Gio16 = int.Parse(item.Gio16.ToString()),
Gio17 = int.Parse(item.Gio17.ToString()),
Gio18 = int.Parse(item.Gio18.ToString()),
Sau18 = int.Parse(item.Sau18h.ToString())
};
if (item.IsNoColor.Trim() == "X")
{
itemSanLuong.isColor = false;
}
else
{
itemSanLuong.isColor = true;
}
//Set color for text
if (itemSanLuong.isColor) // Co to mau
{
if (itemSanLuong.DatSanLuong < 95)
{
itemSanLuong.sColorText = CommonHeader.CSS_TEXT_RED;
}
else if ((itemSanLuong.DatSanLuong >= 95) && (itemSanLuong.DatSanLuong < 100))
{
itemSanLuong.sColorText = CommonHeader.CSS_TEXT_YELLOW;
}
else
{
itemSanLuong.sColorText = CommonHeader.CSS_TEXT_GREEN;
}
}
else // Khong to mau
{
itemSanLuong.sColorText = "";
}
ListSanLuong.Add(itemSanLuong);
}
}
return(ListSanLuong);
}
public ActionResult TestDashboard([Bind(Include = "SelectedCapdo,SelectedGiaTriCapDo,SelectedCongDoan,DateFrom,DateTo")] FilterCoditionModel FilterCodition)
{
var CurrentUser = Session["Username"] as BI_USER;
if (CurrentUser == null)
{
return(RedirectToAction("Index", "Login"));
}
string strResult = String.Empty;
using (TKTDSXEntities dc = new TKTDSXEntities())
{
CommonModel cm = new CommonModel();
try
{
FilterCodition.MANDT = CurrentUser.MANDT;
FilterCodition.SYSID = CurrentUser.SYSID;
strResult = cm.GetPhanQuyen(ref FilterCodition, CurrentUser.Username);
cm.GetCongDoanDauRa(ref FilterCodition);
ViewBag.SelectedCapDo = FilterCodition.ListCapDo;
ViewBag.SelectedGiaTriCapDo = FilterCodition.ListGiaTriCapDo;
ViewBag.SelectedCongDoan = FilterCodition.ListCongDoan;
if (FilterCodition.DateFrom > FilterCodition.DateTo)
{
ViewBag.MessagePQ = "Ngày bắt đầu không được lớn hơn ngày kết thúc";
return(View("TestDashboard", FilterCodition));
}
ViewBag.GiatriCapDo = FilterCodition.SelectedGiaTriCapDo;
ArrayList chartSanLuong = new ArrayList();
ArrayList StatusChart = new ArrayList();
List <TrangThaiChuyen> ListDataStatus = new List <TrangThaiChuyen>();
//Chart San Luong
List <SanLuongNgay> sln = cm.GetSanLuongNgay(FilterCodition, ref chartSanLuong, ref ListDataStatus);
string strData = JsonConvert.SerializeObject(chartSanLuong, Formatting.None);
ViewBag.DataChartSLNgay = new HtmlString(strData);
sln.OrderByDescending(o => o.Ngay);
ViewData["SanLuongNgay"] = sln;
//Chart Status
ArrayList HeaderStatus = new ArrayList();
HeaderStatus.Add((object)string.Format("{0}", "Ngay"));
HeaderStatus.Add((object)string.Format("{0}", "< 95%"));
HeaderStatus.Add((object)string.Format("{0}", "95-100%"));
HeaderStatus.Add((object)string.Format("{0}", "> 100%"));
//HeaderStatus.Add((object)string.Format("{0}", "Khác"));
StatusChart.Add(HeaderStatus);
foreach (TrangThaiChuyen statusCH in ListDataStatus)
{
ArrayList dataChart = new ArrayList();
dataChart.Add(statusCH.Ngay.ToShortDateString());
dataChart.Add(statusCH.redStatus);
dataChart.Add(statusCH.yellowStatus);
dataChart.Add(statusCH.greenStatus);
//dataChart.Add(statusCH.otherStatus);
StatusChart.Add(dataChart);
}
strData = string.Empty;
strData = JsonConvert.SerializeObject(StatusChart, Formatting.None);
ViewBag.DataChartStatus = new HtmlString(strData);
ViewData["StatusChuyen"] = ListDataStatus;
// Lay thong di di lam / nghi phep
List <ThongKeLaoDong> listTKLD = new List <ThongKeLaoDong>();
listTKLD = cm.GetThongKeLaoDong(FilterCodition);
//create array list so luong lao dong --> chart
ArrayList TkldChart = new ArrayList();
ArrayList tkldHeader = new ArrayList();
tkldHeader.Add((object)string.Format("{0}", "Ngày"));
tkldHeader.Add((object)string.Format("{0}", "Tổng LĐ"));
tkldHeader.Add((object)string.Format("{0}", "% Vắng"));
TkldChart.Add(tkldHeader);
foreach (ThongKeLaoDong tkItem in listTKLD)
{
ArrayList item = new ArrayList();
item.Add(tkItem.Ngay.ToShortDateString());
double ptVang = Math.Round((double)tkItem.SoLuongNghi / (double)tkItem.TongSoLuong * 100, 1);
item.Add(tkItem.TongSoLuong);
item.Add(ptVang);
TkldChart.Add(item);
}
strData = JsonConvert.SerializeObject(TkldChart, Formatting.None);
ViewData["ThongKeLD"] = listTKLD;
ViewBag.DataTkld = new HtmlString(strData);
//********************Get Nang Suat lao Dong **************************
ArrayList chartNangSuat = new ArrayList();
List <NangSuatLaoDong> listNangSuatTheoSL = cm.GetNangSuatSanLuong(FilterCodition, ref chartNangSuat);
ViewData["NSLD"] = listNangSuatTheoSL;
strData = JsonConvert.SerializeObject(chartNangSuat, Formatting.None);
ViewBag.DataNsld = new HtmlString(strData);
//********************Get Nang Suat lao Dong **************************
//*********TINH TOAN GIA THANH PHAN XUONG********************
ArrayList chartGiaThanhPhanXuong = new ArrayList();
List <GiaThanhPhanXuong> listGtpx = cm.GetGiaThanhPhanXuong(FilterCodition);
ViewData["GTPX"] = listGtpx;
strData = JsonConvert.SerializeObject(chartGiaThanhPhanXuong, Formatting.None);
ViewBag.DataGtpx = new HtmlString(strData);
ArrayList CommomArray = new ArrayList();
bool iFound = false;
for (int i = 0; i < chartSanLuong.Count; i++)
{
ArrayList lineCommon = new ArrayList();
if (i == 0) //Header
{
lineCommon.Add((object)string.Format("{0}", "Ngày"));
ArrayList headerSanLuong = (ArrayList)chartSanLuong[0];
//add header san luong
for (int s = 1; s < headerSanLuong.Count; s++)
{
lineCommon.Add((object)string.Format("SL-{0}", headerSanLuong[s]));
}
//add header thong ke chuyen
ArrayList headerStatus = (ArrayList)StatusChart[0];
for (int s = 1; s < headerStatus.Count; s++)
{
lineCommon.Add((object)string.Format("ST-{0}", headerStatus[s]));
}
//add header nang suat lao dong
ArrayList headerNS = (ArrayList)chartNangSuat[0];
for (int n = 1; n < headerNS.Count; n++)
{
lineCommon.Add((object)string.Format("NS-{0}", headerNS[n]));
}
//add header thong ke lao dong
ArrayList headerTkld = (ArrayList)TkldChart[0];
for (int l = 1; l < headerTkld.Count; l++)
{
lineCommon.Add((object)string.Format("LD-{0}", headerTkld[l]));
}
}
else //line item
{
ArrayList lineSanLuong = (ArrayList)chartSanLuong[i];
//add line san luong
for (int s = 0; s < lineSanLuong.Count; s++)
{
lineCommon.Add((lineSanLuong[s]));
}
iFound = false;
//add line thong ke chuyen
for (int y = 1; y < StatusChart.Count; y++)
{
ArrayList lineStatus = (ArrayList)StatusChart[y];
if (lineCommon[0].ToString() != lineStatus[0].ToString())
{
continue;
}
iFound = true;
for (int s = 1; s < lineStatus.Count; s++)
{
lineCommon.Add(lineStatus[s]);
}
break;
}
if (!iFound)
{
ArrayList lineStatus = (ArrayList)StatusChart[0];
for (int s = 1; s < lineStatus.Count; s++)
{
lineCommon.Add(0);
}
}
iFound = false;
//add line nang suat
for (int y = 1; y < chartNangSuat.Count; y++)
{
ArrayList line = (ArrayList)chartNangSuat[y];
if (lineCommon[0].ToString() != line[0].ToString())
{
continue;
}
iFound = true;
for (int n = 1; n < line.Count; n++)
{
lineCommon.Add(line[n]);
}
break;
}
if (!iFound)
{
ArrayList line = (ArrayList)chartNangSuat[0];
for (int s = 1; s < line.Count; s++)
{
lineCommon.Add(0);
}
}
//add line thong ke lao dong
iFound = false;
for (int y = 1; y < TkldChart.Count; y++)
{
ArrayList line = (ArrayList)TkldChart[y];
if (lineCommon[0].ToString() != line[0].ToString())
{
continue;
}
iFound = true;
for (int l = 1; l < line.Count; l++)
{
lineCommon.Add(line[l]);
}
break;
}
if (!iFound)
{
ArrayList line = (ArrayList)TkldChart[0];
for (int s = 1; s < line.Count; s++)
{
lineCommon.Add(0);
}
}
}
CommomArray.Add(lineCommon);
}
strData = JsonConvert.SerializeObject(CommomArray, Formatting.None);
ViewBag.DataCommon = new HtmlString(strData);
//*********TINH TOAN GIA THANH PHAN XUONG********************
if (FilterCodition.SelectedCapDo == "NGANH")
{
ViewBag.CapDo = "Ngành";
}
else if (FilterCodition.SelectedCapDo == "KHVUC")
{
ViewBag.CapDo = "Khu Vực";
}
else if (FilterCodition.SelectedCapDo == "WRKCT")
{
ViewBag.CapDo = "Work Center";
}
return(View("TestDashboard", FilterCodition));
}
catch (Exception ex)
{
ViewData["SLCH"] = null;
ViewBag.MessagePQ = "Chưa được cấp quyền" + ex.Message;
return(View("TestDashboard"));
}
}
}
public ActionResult Index([Bind(Include = "SelectedCapdo,SelectedGiaTriCapDo,SelectedCongDoan,DateFrom,DateTo")] FilterCoditionModel FilterCodition)
{
var CurrentUser = Session["Username"] as BI_USER;
if (CurrentUser == null)
{
return(RedirectToAction("Index", "Login"));
}
string strResult = String.Empty;
using (TKTDSXEntities dc = new TKTDSXEntities())
{
CommonModel cm = new CommonModel();
try
{
FilterCodition.MANDT = CurrentUser.MANDT;
FilterCodition.SYSID = CurrentUser.SYSID;
strResult = cm.GetPhanQuyen(ref FilterCodition, CurrentUser.Username);
cm.GetCongDoanDauRa(ref FilterCodition);
ViewBag.SelectedCapDo = FilterCodition.ListCapDo;
ViewBag.SelectedGiaTriCapDo = FilterCodition.ListGiaTriCapDo;
ViewBag.SelectedCongDoan = FilterCodition.ListCongDoan;
if (FilterCodition.DateFrom > FilterCodition.DateTo)
{
ViewBag.MessagePQ = "Ngày bắt đầu không được lớn hơn ngày kết thúc";
return(View("TestDashboard", FilterCodition));
}
ViewBag.GiatriCapDo = FilterCodition.SelectedGiaTriCapDo;
ArrayList chartSanLuong = new ArrayList();
ArrayList StatusChart = new ArrayList();
List <TrangThaiChuyen> ListDataStatus = new List <TrangThaiChuyen>();
//Chart San Luong
List <SanLuongNgay> sln = cm.GetSanLuongNgay(FilterCodition, ref chartSanLuong, ref ListDataStatus);
//string strData = JsonConvert.SerializeObject(chartSanLuong, Formatting.None);
//ViewBag.DataChartSLNgay = new HtmlString(strData);
sln.OrderByDescending(o => o.Ngay);
ViewData["SanLuongNgay"] = sln;
//Chart Status
ArrayList HeaderStatus = new ArrayList();
HeaderStatus.Add((object)string.Format("{0}", "Ngay"));
HeaderStatus.Add((object)string.Format("{0}", "< 95%"));
HeaderStatus.Add((object)string.Format("{0}", "95-100%"));
HeaderStatus.Add((object)string.Format("{0}", "> 100%"));
//HeaderStatus.Add((object)string.Format("{0}", "Khác"));
StatusChart.Add(HeaderStatus);
foreach (TrangThaiChuyen statusCH in ListDataStatus)
{
ArrayList dataChart = new ArrayList();
dataChart.Add(statusCH.Ngay.ToShortDateString());
dataChart.Add(statusCH.redStatus);
dataChart.Add(statusCH.yellowStatus);
dataChart.Add(statusCH.greenStatus);
//dataChart.Add(statusCH.otherStatus);
StatusChart.Add(dataChart);
}
//strData = string.Empty;
//strData = JsonConvert.SerializeObject(StatusChart, Formatting.None);
//ViewBag.DataChartStatus = new HtmlString(strData);
ViewData["StatusChuyen"] = ListDataStatus;
// Lay thong di di lam / nghi phep
List <ThongKeLaoDong> listTKLD = new List <ThongKeLaoDong>();
listTKLD = cm.GetThongKeLaoDong(FilterCodition);
//create array list so luong lao dong --> chart
ArrayList TkldChart = new ArrayList();
ArrayList tkldHeader = new ArrayList();
tkldHeader.Add((object)string.Format("{0}", "Ngày"));
tkldHeader.Add((object)string.Format("{0}", "Tổng LĐ"));
tkldHeader.Add((object)string.Format("{0}", "% Vắng"));
TkldChart.Add(tkldHeader);
foreach (ThongKeLaoDong tkItem in listTKLD)
{
//DayOfWeek dayOfWeek = tkItem.Ngay.DayOfWeek;
//if (dayOfWeek == DayOfWeek.Sunday)
//{
// continue;
//}
ArrayList item = new ArrayList();
item.Add(tkItem.Ngay.ToShortDateString());
double ptVang = Math.Round((double)tkItem.SoLuongNghi / (double)tkItem.TongSoLuong * 100, 1);
item.Add(tkItem.TongSoLuong);
item.Add(ptVang);
TkldChart.Add(item);
}
ViewData["ThongKeLD"] = listTKLD;
//strData = JsonConvert.SerializeObject(TkldChart, Formatting.None);
//ViewBag.DataTkld = new HtmlString(strData);
//********************Get Nang Suat lao Dong **************************
ArrayList chartNangSuat = new ArrayList();
List <NangSuatLaoDong> listNangSuatTheoSL = cm.GetNangSuatSanLuong(FilterCodition, ref chartNangSuat);
ViewData["NSLD"] = listNangSuatTheoSL;
//strData = JsonConvert.SerializeObject(chartNangSuat, Formatting.None);
//ViewBag.DataNsld = new HtmlString(strData);
//********************Get Nang Suat lao Dong **************************
//*********TINH TOAN GIA THANH PHAN XUONG********************
ArrayList chartGiaThanhPhanXuong = new ArrayList();
List <GiaThanhPhanXuong> listGtpx = cm.GetGiaThanhPhanXuong(FilterCodition);
//Data for Chart Gia Thanh Phan Xuong
ArrayList headerGTPX = new ArrayList();
headerGTPX.Add("Công Đoạn");
headerGTPX.Add("Vật Tư");
headerGTPX.Add("Tài Sản");
headerGTPX.Add("Nhân Công");
chartGiaThanhPhanXuong.Add(headerGTPX);
//data for chart nang suat lao dong tong the
List <NangSuatTongThe> listNSTT = new List <NangSuatTongThe>();
if (FilterCodition.SelectedCongDoan != "ALL")
{
// Tính tổng giá trị
GiaThanhPhanXuong tongGTPX = new GiaThanhPhanXuong();
for (int i = 0; i < listGtpx.Count; i++)
{
tongGTPX.gtNhanCongKeHoach += listGtpx[i].gtNhanCongKeHoach;
tongGTPX.gtVatTuKeHoach += listGtpx[i].gtVatTuKeHoach;
tongGTPX.gtTaiSanKeHoach += listGtpx[i].gtTaiSanKeHoach;
tongGTPX.gtNhanCongThucHien += listGtpx[i].gtNhanCongThucHien;
tongGTPX.gtVatTuThucHien += listGtpx[i].gtVatTuThucHien;
tongGTPX.gtTaiSanThucHien += listGtpx[i].gtTaiSanThucHien;
}
tongGTPX.ptNhanCongKeHoach = Math.Round(tongGTPX.gtNhanCongKeHoach / (tongGTPX.gtNhanCongKeHoach +
tongGTPX.gtVatTuKeHoach + tongGTPX.gtTaiSanKeHoach) * 100, 2);
tongGTPX.ptVatTuKeHoach = Math.Round(tongGTPX.gtVatTuKeHoach / (tongGTPX.gtNhanCongKeHoach +
tongGTPX.gtVatTuKeHoach + tongGTPX.gtTaiSanKeHoach) * 100, 2);
tongGTPX.ptTaiSanKeHoach = Math.Round(tongGTPX.gtTaiSanKeHoach / (tongGTPX.gtNhanCongKeHoach +
tongGTPX.gtVatTuKeHoach + tongGTPX.gtTaiSanKeHoach) * 100, 2);
tongGTPX.ptNhanCongThucHien = Math.Round(tongGTPX.gtNhanCongThucHien / (tongGTPX.gtNhanCongThucHien +
tongGTPX.gtVatTuThucHien + tongGTPX.gtTaiSanThucHien) * 100, 2);
tongGTPX.ptVatTuThucHien = Math.Round(tongGTPX.gtVatTuThucHien / (tongGTPX.gtNhanCongThucHien +
tongGTPX.gtVatTuThucHien + tongGTPX.gtTaiSanThucHien) * 100, 2);
tongGTPX.ptTaiSanThucHien = Math.Round(tongGTPX.gtTaiSanThucHien / (tongGTPX.gtNhanCongThucHien +
tongGTPX.gtVatTuThucHien + tongGTPX.gtTaiSanThucHien) * 100, 2);
//add row ke hoach
ArrayList lineKeHoach = new ArrayList();
lineKeHoach.Add(string.Format("KH-{0}", FilterCodition.SelectedCongDoan));
lineKeHoach.Add(tongGTPX.ptVatTuKeHoach);
lineKeHoach.Add(tongGTPX.ptTaiSanKeHoach);
lineKeHoach.Add(tongGTPX.ptNhanCongKeHoach);
//add line to list
chartGiaThanhPhanXuong.Add(lineKeHoach);
//add line thuc hien
ArrayList lineThucHien = new ArrayList();
lineThucHien.Add(string.Format("TH-{0}", FilterCodition.SelectedCongDoan));
lineThucHien.Add(tongGTPX.ptVatTuThucHien);
lineThucHien.Add(tongGTPX.ptTaiSanThucHien);
lineThucHien.Add(tongGTPX.ptNhanCongThucHien);
//add line to list
chartGiaThanhPhanXuong.Add(lineThucHien);
//tinh nhan cong binh quan
int iCountLD = 0;
double iLDBQ = 0;
double dNSTT = 0;
double dTongNS = 0;
foreach (NangSuatLaoDong nsld in listNangSuatTheoSL)
{
if (nsld.CongDoan != FilterCodition.SelectedCongDoan)
{
continue;
}
iLDBQ += nsld.SoLuongLaoDong;
dTongNS += nsld.NangSuat;
iCountLD++;
}
if (iCountLD > 0)
{
iLDBQ = iLDBQ / (double)iCountLD;
dTongNS = dTongNS / (double)iCountLD;
dNSTT = Math.Round((Double)((tongGTPX.gtNhanCongThucHien + tongGTPX.gtVatTuThucHien + tongGTPX.gtTaiSanThucHien) / iLDBQ), 2);
}
NangSuatTongThe lineNSTT = new NangSuatTongThe();
lineNSTT.CongDoan = FilterCodition.SelectedCongDoan;
lineNSTT.SoLuongLaoDong = Math.Round(iLDBQ, 0);
lineNSTT.ptChiPhiNc = Math.Round(tongGTPX.ptNhanCongThucHien, 2);
lineNSTT.ptChiPhiVt = Math.Round(tongGTPX.ptVatTuThucHien, 2);
lineNSTT.ptChiPhiTs = Math.Round(tongGTPX.ptTaiSanThucHien, 2);
lineNSTT.NangSuatTT = Math.Round(dNSTT, 2);
lineNSTT.NangSuatSL = Math.Round(dTongNS, 2);
listNSTT.Add(lineNSTT);
}
else
{
foreach (SelectListItem cdoan in FilterCodition.ListCongDoan)
{
if (cdoan.Value == "ALL")
{
continue;
}
long iCount = 0;
GiaThanhPhanXuong tongGTPX = new GiaThanhPhanXuong();
for (int i = 0; i < listGtpx.Count; i++)
{
if (cdoan.Value != listGtpx[i].CongDoan)
{
continue;
}
tongGTPX.gtNhanCongKeHoach += listGtpx[i].gtNhanCongKeHoach;
tongGTPX.gtVatTuKeHoach += listGtpx[i].gtVatTuKeHoach;
tongGTPX.gtTaiSanKeHoach += listGtpx[i].gtTaiSanKeHoach;
tongGTPX.gtNhanCongThucHien += listGtpx[i].gtNhanCongThucHien;
tongGTPX.gtVatTuThucHien += listGtpx[i].gtVatTuThucHien;
tongGTPX.gtTaiSanThucHien += listGtpx[i].gtTaiSanThucHien;
iCount++;
}
tongGTPX.ptNhanCongKeHoach = Math.Round(tongGTPX.gtNhanCongKeHoach / (tongGTPX.gtNhanCongKeHoach +
tongGTPX.gtVatTuKeHoach + tongGTPX.gtTaiSanKeHoach) * 100, 2);
tongGTPX.ptVatTuKeHoach = Math.Round(tongGTPX.gtVatTuKeHoach / (tongGTPX.gtNhanCongKeHoach +
tongGTPX.gtVatTuKeHoach + tongGTPX.gtTaiSanKeHoach) * 100, 2);
tongGTPX.ptTaiSanKeHoach = Math.Round(tongGTPX.gtTaiSanKeHoach / (tongGTPX.gtNhanCongKeHoach +
tongGTPX.gtVatTuKeHoach + tongGTPX.gtTaiSanKeHoach) * 100, 2);
tongGTPX.ptNhanCongThucHien = Math.Round(tongGTPX.gtNhanCongThucHien / (tongGTPX.gtNhanCongThucHien +
tongGTPX.gtVatTuThucHien + tongGTPX.gtTaiSanThucHien) * 100, 2);
tongGTPX.ptVatTuThucHien = Math.Round(tongGTPX.gtVatTuThucHien / (tongGTPX.gtNhanCongThucHien +
tongGTPX.gtVatTuThucHien + tongGTPX.gtTaiSanThucHien) * 100, 2);
tongGTPX.ptTaiSanThucHien = Math.Round(tongGTPX.gtTaiSanThucHien / (tongGTPX.gtNhanCongThucHien +
tongGTPX.gtVatTuThucHien + tongGTPX.gtTaiSanThucHien) * 100, 2);
//add row ke hoach
ArrayList lineKeHoach = new ArrayList();
lineKeHoach.Add(string.Format("KH-{0}", cdoan.Value));
lineKeHoach.Add(tongGTPX.ptVatTuKeHoach);
lineKeHoach.Add(tongGTPX.ptTaiSanKeHoach);
lineKeHoach.Add(tongGTPX.ptNhanCongKeHoach);
//add line to list
chartGiaThanhPhanXuong.Add(lineKeHoach);
//add line thuc hien
ArrayList lineThucHien = new ArrayList();
lineThucHien.Add(string.Format("TH-{0}", cdoan.Value));
lineThucHien.Add(tongGTPX.ptVatTuThucHien);
lineThucHien.Add(tongGTPX.ptTaiSanThucHien);
lineThucHien.Add(tongGTPX.ptNhanCongThucHien);
//add line to list
chartGiaThanhPhanXuong.Add(lineThucHien);
//tinh nhan cong binh quan
int iCountLD = 0;
double iLDBQ = 0;
double dNSTT = 0;
double dTongNS = 0;
foreach (NangSuatLaoDong nsld in listNangSuatTheoSL)
{
if (nsld.CongDoan != cdoan.Value)
{
continue;
}
iLDBQ += nsld.SoLuongLaoDong;
dTongNS += nsld.NangSuat;
iCountLD++;
}
if (iCountLD > 0)
{
iLDBQ = iLDBQ / (double)iCountLD;
dTongNS = dTongNS / (double)iCountLD;
dNSTT = Math.Round((Double)((tongGTPX.gtNhanCongThucHien + tongGTPX.gtVatTuThucHien + tongGTPX.gtTaiSanThucHien) / iLDBQ), 2);
}
NangSuatTongThe lineNSTT = new NangSuatTongThe();
lineNSTT.CongDoan = cdoan.Value;
lineNSTT.SoLuongLaoDong = Math.Round(iLDBQ, 0);
lineNSTT.ptChiPhiNc = Math.Round(tongGTPX.ptNhanCongThucHien, 2);
lineNSTT.ptChiPhiVt = Math.Round(tongGTPX.ptVatTuThucHien, 2);
lineNSTT.ptChiPhiTs = Math.Round(tongGTPX.ptTaiSanThucHien, 2);
lineNSTT.NangSuatTT = Math.Round(dNSTT, 2);
lineNSTT.NangSuatSL = Math.Round(dTongNS, 2);
listNSTT.Add(lineNSTT);
}
}
ViewData["NSTT"] = listNSTT;
string strData = JsonConvert.SerializeObject(chartGiaThanhPhanXuong, Formatting.None);
ViewBag.DataGtpx = new HtmlString(strData);
ArrayList CommomArray = new ArrayList();
bool iFound = false;
for (int i = 0; i < chartSanLuong.Count; i++)
{
ArrayList lineCommon = new ArrayList();
if (i == 0) //Header
{
lineCommon.Add((object)string.Format("{0}", "Ngày"));
ArrayList headerSanLuong = (ArrayList)chartSanLuong[0];
//add header san luong
for (int s = 1; s < headerSanLuong.Count; s++)
{
lineCommon.Add((object)string.Format("SL-{0}", headerSanLuong[s]));
}
//add header thong ke chuyen
ArrayList headerStatus = (ArrayList)StatusChart[0];
for (int s = 1; s < headerStatus.Count; s++)
{
lineCommon.Add((object)string.Format("ST-{0}", headerStatus[s]));
}
//add header nang suat lao dong
ArrayList headerNS = (ArrayList)chartNangSuat[0];
for (int n = 1; n < headerNS.Count; n++)
{
lineCommon.Add((object)string.Format("NS-{0}", headerNS[n]));
}
//add header thong ke lao dong
ArrayList headerTkld = (ArrayList)TkldChart[0];
for (int l = 1; l < headerTkld.Count; l++)
{
lineCommon.Add((object)string.Format("LD-{0}", headerTkld[l]));
}
}
else //line item
{
ArrayList lineSanLuong = (ArrayList)chartSanLuong[i];
//add line san luong
for (int s = 0; s < lineSanLuong.Count; s++)
{
lineCommon.Add((lineSanLuong[s]));
}
iFound = false;
//add line thong ke chuyen
for (int y = 1; y < StatusChart.Count; y++)
{
ArrayList lineStatus = (ArrayList)StatusChart[y];
if (lineCommon[0].ToString() != lineStatus[0].ToString())
{
continue;
}
iFound = true;
for (int s = 1; s < lineStatus.Count; s++)
{
lineCommon.Add(lineStatus[s]);
}
break;
}
if (!iFound)
{
ArrayList lineStatus = (ArrayList)StatusChart[0];
for (int s = 1; s < lineStatus.Count; s++)
{
lineCommon.Add(0);
}
}
iFound = false;
//add line nang suat
for (int y = 1; y < chartNangSuat.Count; y++)
{
ArrayList line = (ArrayList)chartNangSuat[y];
if (lineCommon[0].ToString() != line[0].ToString())
{
continue;
}
iFound = true;
for (int n = 1; n < line.Count; n++)
{
lineCommon.Add(line[n]);
}
break;
}
if (!iFound)
{
ArrayList line = (ArrayList)chartNangSuat[0];
for (int s = 1; s < line.Count; s++)
{
lineCommon.Add(0);
}
}
//add line thong ke lao dong
iFound = false;
for (int y = 1; y < TkldChart.Count; y++)
{
ArrayList line = (ArrayList)TkldChart[y];
if (lineCommon[0].ToString() != line[0].ToString())
{
continue;
}
iFound = true;
for (int l = 1; l < line.Count; l++)
{
lineCommon.Add(line[l]);
}
break;
}
if (!iFound)
{
ArrayList line = (ArrayList)TkldChart[0];
for (int s = 1; s < line.Count; s++)
{
lineCommon.Add(0);
}
}
}
CommomArray.Add(lineCommon);
}
strData = JsonConvert.SerializeObject(CommomArray, Formatting.None);
ViewBag.DataCommon = new HtmlString(strData);
//*********TINH TOAN GIA THANH PHAN XUONG********************
if (FilterCodition.SelectedCapDo == "NGANH")
{
ViewBag.CapDo = "NGÀNH";
}
else if (FilterCodition.SelectedCapDo == "KHVUC")
{
ViewBag.CapDo = "KHU VỰC";
}
else if (FilterCodition.SelectedCapDo == "WRKCT")
{
ViewBag.CapDo = "WORK CENTER";
}
return(View("Index", FilterCodition));
}
catch (Exception ex)
{
ViewData["SanLuongNgay"] = null;
ViewBag.MessagePQ = "Chưa được cấp quyền" + ex.Message;
return(View("Index"));
}
}
}
public ActionResult RefreshCD(string GiaTriCapDoID)
{
string strMandt = "900";
string strSysid = "P01";
TKTDSXEntities dc = new TKTDSXEntities();
var CurrentUser = Session["Username"] as BI_USER;
List <SelectListItem> items = new List <SelectListItem>();
BI_PHAN_QUYEN dataPQ = dc.BI_PHAN_QUYEN.Where(p => p.GiaTri == GiaTriCapDoID && p.Username == CurrentUser.Username).FirstOrDefault();
IQueryable <string> listCD;
string strTenCD = string.Empty;
items.Add(new SelectListItem()
{
Text = "Tất Cả", Value = "ALL"
});
switch (dataPQ.CapDo)
{
case "NGANH":
listCD = dc.BI_ZQLSX.Where(w => w.MANDT == strMandt && w.SYSID == strSysid &&
w.NGANH == dataPQ.GiaTri).Select(s => s.CDOAN).Distinct();
foreach (string strCD in listCD)
{
strTenCD = dc.BI_ZQLSX.Where(w => w.MANDT == strMandt && w.SYSID == strSysid &&
w.NGANH == dataPQ.GiaTri).Select(s => s.TENCD).FirstOrDefault();
items.Add(new SelectListItem()
{
Text = strTenCD, Value = strCD
});
}
break;
case "KHVUC":
listCD = dc.BI_ZQLSX.Where(w => w.MANDT == strMandt && w.SYSID == strSysid &&
w.KHVUC == dataPQ.GiaTri).Select(s => s.CDOAN).Distinct();
foreach (string strCD in listCD)
{
strTenCD = dc.BI_ZQLSX.Where(w => w.MANDT == strMandt && w.SYSID == strSysid &&
w.KHVUC == dataPQ.GiaTri).Select(s => s.TENCD).FirstOrDefault();
items.Add(new SelectListItem()
{
Text = strTenCD, Value = strCD
});
}
break;
case "WRKCT":
listCD = dc.BI_ZQLSX.Where(w => w.MANDT == strMandt && w.SYSID == strSysid &&
w.WRKCT == dataPQ.GiaTri).Select(s => s.CDOAN).Distinct();
foreach (string strCD in listCD)
{
strTenCD = dc.BI_ZQLSX.Where(w => w.MANDT == strMandt && w.SYSID == strSysid &&
w.WRKCT == dataPQ.GiaTri).Select(s => s.TENCD).FirstOrDefault();
items.Add(new SelectListItem()
{
Text = strTenCD, Value = strCD
});
}
break;
}
return(Json(items, JsonRequestBehavior.AllowGet));
}
public ActionResult ChangePassword(UserManager user)
{
var loggedUser = Session["Username"] as BI_USER;
user.Username = loggedUser.Username;
if (user.JobPosition == null)
{
user.JobPosition = loggedUser.GhiChu;
}
if (loggedUser == null)
{
RedirectToAction("Index", "Login");
}
if ((user.CurrentPassword == null) && (user.Password == null) &&
(user.PasswordCofirm == null))
{
return(View("ChangePassword", user));
}
if (!ModelState.IsValid)
{
return(View("ChangePassword", user));
}
using (TKTDSXEntities dc = new TKTDSXEntities())
{
string strPwd = user.CurrentPassword.Trim();
string strEncrypt = CryptorEngine.Encrypt(strPwd, true);
//Check exist user
BI_USER existUser = dc.BI_USER.Where(x => x.MANDT == "900" && x.SYSID == "P01" &&
x.Username == user.Username).FirstOrDefault();
if ((user.CurrentPassword != null) && (strEncrypt != existUser.Password))
{
ModelState.AddModelError("CurrentPassword", "Current Password Incorrect");
return(View("ChangePassword", user));
}
else
{
user.CurrentPassword = existUser.Password;
}
if ((user.Password != user.PasswordCofirm) && ((user.Password != null) || (user.PasswordCofirm != null)))
{
ModelState.AddModelError("Password", "New Password do not match with confirm password");
return(View("ChangePassword", user));
}
if (user.Password == existUser.Password)
{
ModelState.AddModelError("Password", "New Password must different exist password");
return(View("ChangePassword", user));
}
else
{
existUser.Password = user.Password;
existUser.GhiChu = user.JobPosition;
string newPwd = existUser.Password.Trim();
string strEncryptPwd = CryptorEngine.Encrypt(newPwd, true);
existUser.Password = strEncryptPwd;
dc.BI_USER.Attach(existUser);
var entry = dc.Entry(existUser);
entry.Property(e => e.Password).IsModified = true;
entry.Property(e => e.GhiChu).IsModified = true;
dc.SaveChanges();
Session["Username"] = existUser;
ViewBag.SuccessChangePassword = "******";
return(View("ChangePassword", user));
}
}
}
