/// <summary>
/// 使用者預約借用
/// </summary>
public ActionResult UserReserve()
{
EmpData ED = new EmpData();
if (Session["SessionEmpID"] == null || Session["SessionRole"] == null) //當沒有登入，沒SessionEmpID，無權限前往此頁面，return回登入畫面
{
ViewBag.Message = false;
return(View("SpaceView"));
}
if (Session["SessionRole"] != null)
{
string role = Session["SessionRole"].ToString();
if (role != "User")
{
ViewBag.Message = false;
return(View("SpaceView"));
}
}
if (Session["SessionEmpID"] != null)
{
string Empid = Session["SessionEmpID"].ToString();
ED = db.EmpData.Where(x => x.EmpID == Empid).FirstOrDefault();
}
return(View(ED));
}
public ActionResult Login(EmpData emplogin)
{
using (EasyCardEntities4 data = new EasyCardEntities4())
{
var obj = data.EmpData.Where(x => x.EmpID == emplogin.EmpID && x.EmpPwd == emplogin.EmpPwd).FirstOrDefault();
if (obj != null)
{
Session["EmpID"] = obj.EmpID;
Session["EmpName"] = obj.EmpName;
Session["EmpPwd"] = obj.EmpPwd;
Session["EmpDept"] = obj.EmpDept;
Session["EmpRole"] = obj.Role;
Session["EmpState"] = obj.EmpState;
if (obj.Role == "admin" || obj.Role == "Superadmin")
{
return(RedirectToAction("AdmBorrowIndex", "AdminBorrow"));
}
else
{
return(RedirectToAction("UserBorrow", "UserBorrow"));
}
}
//密碼錯誤訊息
ModelState.AddModelError("EmpPwd", "登入錯誤，請輸入正確帳號、密碼。");
return(View(emplogin));
}
}
public ActionResult UserBorrow(RecordDataViewModel getrecorddata)
{
using (EasyCardEntities4 Data = new EasyCardEntities4())
{
if (getrecorddata.EmpID != Session["EmpID"].ToString() || getrecorddata.EmpName != Session["EmpName"].ToString())
{
ModelState.AddModelError("UseDay", "請使用本人ID、姓名借用");
return(View(getrecorddata));
}
EmpData empdata = Data.EmpData.Where(x => x.EmpID == getrecorddata.EmpID).FirstOrDefault();
if (empdata.EmpState == "已借用")//防止重複借卡
{
ModelState.AddModelError("UseDay", "尚有未歸還或已預約卡片，請先歸還");
return(View(getrecorddata));
}
else
{
empdata.EmpState = "已預約";
RecordData recorddata = new RecordData()
{
RecordID = Data.RecordData.Count() + 1,
EmpID = getrecorddata.EmpID,
TimeLend = getrecorddata.TimeLend,
UseDay = getrecorddata.UseDay,
CardID = "0001", //預約時，預設卡號"0001"為預約卡
RecordDisable = "False",
RecordState = "已預約",
};
Data.RecordData.Add(recorddata);
Data.SaveChanges();
return(RedirectToAction("UserRecord"));
}
}
}
public JsonResult ReserveConfirm(EmpData EData, CardData CData, RecordData RData, string mistake = "")
{
CardData C = db.CardData.Where(x => x.CardID == CData.CardID).FirstOrDefault();
EmpData E = db.EmpData.Where(x => x.EmpID == EData.EmpID).FirstOrDefault();
//判斷卡片是否跟借用員工同部門
if (E.EmpDept != C.CardDept)
{
mistake = "Case01";
return(Json(mistake));
}
//判斷卡片狀態
if (C.CardState == "已借用")
{
mistake = "Case02";
return(Json(mistake));
}
E.EmpState = "已借用";
C.CardState = "已借用";
RecordData R = db.RecordData.Where(x => x.RecordNumber == RData.RecordNumber).FirstOrDefault();
R.CardID = C.CardID;
R.TimeLend = RData.TimeLend;
R.UseDay = RData.UseDay;
R.RecordState = "已借用";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult AdmEdit(RecordDataViewModel getrecorddata)
{
using (EasyCardEntities4 Data = new EasyCardEntities4())
{
CardData carddata = Data.CardData.Where(x => x.CardName == getrecorddata.CardName).FirstOrDefault();
//if (carddata.CardState =="已借出")//防止選到已借出的卡片
//{
//}
//else
{
carddata.CardState = "已借出";
}
EmpData empdata = Data.EmpData.Where(x => x.EmpID == getrecorddata.EmpID).FirstOrDefault();
empdata.EmpState = "已借用";
//RecordData 儲存
RecordData recorddata = Data.RecordData.Where(x => x.RecordID == getrecorddata.RecordID).FirstOrDefault();
recorddata.EmpID = getrecorddata.EmpID;
recorddata.CardID = carddata.CardID;
recorddata.TimeLend = getrecorddata.TimeLend;
recorddata.UseDay = getrecorddata.UseDay;
recorddata.RecordState = "未歸還";
Data.SaveChanges();
}
return(RedirectToAction("AdmReturnIndex"));
}
private EmpData ConvertDataReaderIntoModel(MySqlDataReader dr)
{
EmpData obj = new EmpData();
obj.employeeName = Convert.ToString(dr["UserName"]);
return(obj);
}
public ActionResult EmpSNsearch(ECSViewModel ECS, string empsn = "")
{
EmpData ED = db.EmpData.Where(x => x.EmpSN == empsn).FirstOrDefault();
ECS.EmpID = ED.EmpID;
ECS.EmpName = ED.EmpName;
return(Json(ECS, JsonRequestBehavior.AllowGet));
}
public JsonResult EmpCreat(EmpData DataCreat)
{
db.EmpData.Add(DataCreat);
DataCreat.Disable = "N";
DataCreat.EmpState = "未借用";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult Index(string searchString, int page = 1, int pageSize = 2)
{
var data = new EmpData();
var model = data.ListAllEmployee(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public ActionResult EmpCreate(EmpData empdata)
{
using (EasyCardEntities4 Data = new EasyCardEntities4())
{
empdata.EmpDisable = "False";
Data.EmpData.Add(empdata);
Data.SaveChanges();
}
return(RedirectToAction("EmployeeIndex"));
}
public ActionResult Edit(long ID)
{
var session = new EditEmp();
session.USERID = ID;
Session.Add(CommonConstants.EMP_SESSION, session);
var model = new EmpData().GetByID(ID);
return(View(model));
}
public JsonResult EmpEdit(EmpData DataEdit)
{
EmpData E = db.EmpData.Where(x => x.EmpID == DataEdit.EmpID).FirstOrDefault();
E.EmpID = DataEdit.EmpID;
E.EmpName = DataEdit.EmpName;
E.EmpDept = DataEdit.EmpDept;
E.Email = DataEdit.Email;
E.EmpState = DataEdit.EmpState;
E.EmpSN = DataEdit.EmpSN;
E.Role = DataEdit.Role;
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public string addEmpData(EmpData emp)
{
string request = JsonConvert.SerializeObject(emp);
string response = "";
MySqlDataReader dr = CallEmpDetail_USP(request, OperationType.SAVE);
while (dr.Read())
{
response = Convert.ToString(dr["_errorOutput"]);
}
dr.Close();
return(response);
}
public EmpInfo GetById(int empID)
{
EmpData objempdata = new EmpData();
objempdata.GetEmpDateaFromSQl();
EmpInfo _empInfo = new EmpInfo()
{
EmpId = empID,
Name = "Tes123",
Dept = "IT",
};
return(_empInfo);
}
public JsonResult UserReserve(EmpData E, RecordData R)
{
EmpData ED = db.EmpData.Where(x => x.EmpID == E.EmpID).FirstOrDefault();
ED.EmpState = "已預約";
db.RecordData.Add(R);
R.RecordNumber = db.RecordData.Select(x => x.RecordNumber).Max(); //找出編號最大，並加1
R.RecordNumber++;
R.Disable = "N";
R.CardID = "未選取";
R.RecordState = "已預約";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public List <EmpData> getAllCustomerData()
{
string response = JsonConvert.SerializeObject(null);
MySqlDataReader dr = CallEmpDetail_USP(response, OperationType.GET_All);
List <EmpData> customersData = new List <EmpData>();
while (dr.Read())
{
EmpData customerData = ConvertDataReaderIntoModel(dr);
customersData.Add(customerData);
}
dr.Close();
return(customersData);
}
public JsonResult BorrowCreat(ECSViewModel ECS, EmpData EData, CardData CData, RecordData RData, string mistake = "", string empsn = "")
{
//將輸入empsn的員工資料，搜尋出來
if (!string.IsNullOrWhiteSpace(empsn))
{
EmpData ED = db.EmpData.Where(x => x.EmpSN == empsn).FirstOrDefault();
ECS.EmpID = ED.EmpID;
ECS.EmpName = ED.EmpName;
return(Json(ECS, JsonRequestBehavior.AllowGet));
}
EmpData E = db.EmpData.Where(x => x.EmpID == EData.EmpID).FirstOrDefault();
CardData C = db.CardData.Where(x => x.CardID == CData.CardID).FirstOrDefault();
//判斷此員工是否為預約與借用狀態
if (E.EmpState == "已預約" || E.EmpState == "已借用")
{
mistake = "Case01";
return(Json(mistake));
}
//判斷卡片是否跟借用員工同部門
if (E.EmpDept != C.CardDept)
{
mistake = "Case02";
return(Json(mistake));
}
//判斷卡片狀態
if (C.CardState == "已借用")
{
mistake = "Case03";
return(Json(mistake));
}
E.EmpState = "已借用";
C.CardState = "已借用";
db.RecordData.Add(RData);
RData.RecordNumber = db.RecordData.Select(x => x.RecordNumber).Max(); //找出編號最大，並加1
RData.RecordNumber++;
RData.CardID = C.CardID;
RData.Disable = "N";
RData.RecordState = "已借用";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult EmpEdit(EmpData getempdata)
{
using (EasyCardEntities4 Data = new EasyCardEntities4())
{
if (ModelState.IsValid)
{
EmpData empdata = Data.EmpData.Where(x => x.EmpID == getempdata.EmpID).FirstOrDefault();
empdata.EmpID = getempdata.EmpID;
empdata.EmpCardCode = getempdata.EmpCardCode;
empdata.EmpDept = getempdata.EmpDept;
empdata.EmpName = getempdata.EmpName;
empdata.Email = getempdata.Email;
empdata.EmpState = getempdata.EmpState;
empdata.Role = getempdata.Role;
Data.SaveChanges();
}
return(RedirectToAction("EmployeeIndex"));
}
}
public ActionResult Create(EmployeeViewModel model)
{
if (ModelState.IsValid)
{
model.GroupID = "EMP";
var data = new EmpData();
if (data.insert(model) != -1)
{
SetAlert("Thêm nhân viên thành công", "success");
return(RedirectToAction("Index", "Employee"));
}
else
{
SetAlert("Người này đã là nhân viên của cửa hàng", "error");
}
}
SetViewBagUser();
return(View());
}
public JsonResult ReturnConfirm(EmpData EData, CardData CData, RecordData RData)
{
EmpData E = db.EmpData.Where(x => x.EmpID == EData.EmpID).FirstOrDefault();
E.EmpState = "未借用";
RecordData R = db.RecordData.Where(x => x.RecordNumber == RData.RecordNumber).FirstOrDefault();
R.TimeReturn = DateTime.Now; //////取得按鈕後時間
R.RecordState = "已歸還";
CardData C = db.CardData.Where(x => x.CardName == CData.CardName).FirstOrDefault();
C.CardState = "可使用";
R.TotalSpent = CData.CardAmount - C.CardAmount;
if (CData.CardAmount != null)
{
C.CardAmount = C.CardAmount - CData.CardAmount;
}
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public void CanSerialize()
{
var table = new DataTable("User");
table.Columns.Add("Id", typeof(int));
table.Columns.Add("Name", typeof(string));
table.Columns.Add("Salary", typeof(decimal));
var row = table.NewRow();
row["Id"] = 1;
row["Name"] = "John Doe";
row["Salary"] = 15.5m;
table.Rows.Add(row);
var dbStream = new DatabaseStream(table.CreateDataReader());
String EmpData;
dbStream.dtReader.Read();
EmpData = dbStream.dtReader[0].ToString() + "," + dbStream.dtReader[1].ToString() + "," + dbStream.dtReader[2].ToString();
byte[] bytes = Encoding.ASCII.GetBytes(EmpData.ToString());
int numBytesToRead = (int)EmpData.Length;
int numBytesRead = 0;
if (dbStream.Read(bytes, numBytesRead, numBytesRead) == 1)
{
byte[] XMLSerial = dbStream.xmlBytes;
}
Console.Write("Success");
}
public ActionResult AdmBorrow(RecordDataViewModel getrecorddata)
{
using (EasyCardEntities4 Data = new EasyCardEntities4())
{
CardData carddata = Data.CardData.Where(x => x.CardName == getrecorddata.CardName).FirstOrDefault();
//if (carddata.CardState == "已借出")//防止選到已借出的卡片
//{
//}
//else
{
carddata.CardState = "已借出";
getrecorddata.CardID = carddata.CardID;
}
EmpData empdata = Data.EmpData.Where(x => x.EmpID == getrecorddata.EmpID).FirstOrDefault();
//if (empdata.EmpState == "已借用")//防止重複借卡
//{
//}
//else
{
empdata.EmpState = "已借用";
}
RecordData recorddata = new RecordData()
{
RecordID = Data.RecordData.Count() + 1,
EmpID = getrecorddata.EmpID,
CardID = getrecorddata.CardID,
TimeLend = getrecorddata.TimeLend,
UseDay = getrecorddata.UseDay,
RecordDisable = "False",
RecordState = "未歸還",
};
Data.RecordData.Add(recorddata);
Data.SaveChanges();
}
return(RedirectToAction("AdmReturnIndex"));
}
public ActionResult Edit(EmployeeViewModel model)
{
var session = (EditEmp)Session[CommonConstants.EMP_SESSION];
model.GroupID = "EMP";
model.ID = session.USERID;
var data = new EmpData();
var user = new UserData();
model.EmpID = user.GetEMPID(session.USERID);
var result = data.update(model);
if (result)
{
SetAlert("Sửa nhân viên thành công", "success");
return(RedirectToAction("Index", "Employee"));
}
else
{
SetAlert("Sửa không thành công", "error");
}
return(View());
}
// 歸還確認
public ActionResult AdmReturnConfirm(RecordDataViewModel getrecorddata)
{
using (EasyCardEntities4 Data = new EasyCardEntities4())
{
CardData carddata = Data.CardData.Where(x => x.CardName == getrecorddata.CardName).FirstOrDefault();
carddata.CardState = "可使用";
carddata.CardAmount = getrecorddata.CardAmount;
EmpData empdata = Data.EmpData.Where(x => x.EmpID == getrecorddata.EmpID).FirstOrDefault();
empdata.EmpState = "可借用";
//RecordData 儲存
RecordData recorddata = Data.RecordData.Where(x => x.RecordID == getrecorddata.RecordID).FirstOrDefault();
recorddata.EmpID = getrecorddata.EmpID;
recorddata.CardID = carddata.CardID;
recorddata.TimeLend = getrecorddata.TimeLend;
recorddata.UseDay = getrecorddata.UseDay;
recorddata.TimeReturn = DateTime.Now;
recorddata.RecordState = "已歸還";
Data.SaveChanges();
return(RedirectToAction("AdmReturnIndex"));
}
}
public ActionResult Update(EmpData empData)
{
return(Json(empDataOper.Update(empData)));
}
public ActionResult Del(EmpData empData)
{
return(Json(empDataOper.Del(empData)));
}
public string addNewEmployee(EmpData emp)
{
return(JsonConvert.SerializeObject(customerService.addEmpData(emp)));
}
public ActionResult Add(EmpData empData)
{
return(Json(empDataOper.Add(empData)));
}
public string addEmpData(EmpData emp)
{
return(empDataDAL.addEmpData(emp));
}
public EmployeeCreateResponse()
{
status = string.Empty;
data = new EmpData();
message = string.Empty;
}
