public JsonResult GetListStaffs(int staffID) { try { StaffData st = new StaffData(); List <Staffs> item = new List <Staffs>(); item = st.GetStaff(staffID); List <StaffRole> item2 = new List <StaffRole>(); item2 = st.GetListStaffRole(0); return(Json(new { data = item, dataStaffRole = item2, success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { data = ex.Message, success = false }, JsonRequestBehavior.AllowGet)); } }
public List <ListCustomerOnMobile> GetListCustomerOnMobile(int StaffID) { StaffData st = new StaffData(); List <Staffs> item = new List <Staffs>(); item = st.GetStaff(StaffID); Staffs staff = new Staffs(); staff = item.FirstOrDefault(); List <ListCustomerOnMobile> list = new List <ListCustomerOnMobile>(); MySqlConnection ObjConn = DBHelper.ConnectDb(ref errMsg); try { string sqlStr = @" SELECT c.CustomerId,ct.ContractID,CONCAT(c.CustomerTitleName,c.CustomerFirstName,' ',c.CustomerLastName) AS CustomerName ,ct.ContractStartDate,ct.ContractPeriod,ct.ContractPayEveryDay,ct.ContractSpecialholiday ,ct.ContractNumber,ct.ContractExpDate,ct.ContractAmount,ct.ContractPayment, (ct.ContractPayment-d.TotalPay ) AS TotalPay ,( SELECT DATE(DateAsOf) FROM daily_receipts WHERE ContractID=ct.ContractID AND CustomerID=c.CustomerId AND PriceReceipts>0 ORDER BY DateAsOf DESC LIMIT 1) AS lastDate FROM customer c LEFT JOIN contract ct ON c.CustomerId=ct.contractCustomerID LEFT JOIN (SELECT SUM(PriceReceipts)AS TotalPay , ContractID ,CustomerID FROM daily_receipts WHERE Deleted=0 GROUP BY ContractID ,CustomerID ) d ON d.ContractID=ct.ContractID AND d.CustomerID=ct.ContractCustomerID WHERE ct.ContractID IS NOT NULL AND ct.contractstatus=1 and ct.Activated=1 and ct.Deleted=0 and c.Deleted=0 "; DataTable dt1 = DBHelper.List("select * FROM staffrolepermission where StaffPermissionID=23 AND StaffRoleID=" + staff.StaffRoleID, ObjConn); if (dt1.Rows.Count != 1) { sqlStr += "AND c.SaleID=" + StaffID; } DataTable dt = DBHelper.List(sqlStr, ObjConn); if (dt != null && dt.Rows.Count > 0) { list = ListCustomerOnMobile.ToObjectList(dt); } return(list); } catch (Exception ex) { throw new Exception(ex.Message); } finally { ObjConn.Close(); } }
public JsonResult GetStaffs(int staffroleId, int zoneId) { // รับค่าราคา StaffData st = new StaffData(); DataTable dt = new DataTable(); List <ListItems> item = new List <ListItems>(); dt = st.GetStaff(staffroleId, zoneId); if (dt.Rows.Count > 0) { item = dt.AsEnumerable().Select(dr => new ListItems() { ID = dr.Field <int>("StaffID"), Value = dr.Field <string>("StaffTitleName") + dr.Field <string>("StaffFirstName") + " " + dr.Field <string>("StaffLastName"), }).ToList(); } return(Json(new { data = item, success = true }, JsonRequestBehavior.AllowGet)); }