public static bool GetCMSCodeValidation(string Group, string code) { DataTable table = new DataTable(); table = new AdminDataService().GetCMSCodeValidation(Group, code).Tables[0]; return(table.Rows.Count > 0); }
public static bool Get_UserAccess(string Access, string RoleID) { DataTable table = new DataTable(); table = new AdminDataService().Get_UserAccess(Access, RoleID).Tables[0]; return(table.Rows.Count > 0); }
public static bool ACCodeValidaton(string AcCode) { DataTable table = new DataTable(); table = new AdminDataService().ACCodeValidaton(AcCode).Tables[0]; return(table.Rows.Count > 0); }
public static bool Idv_Chetana_Get_Validate_PurchaseInvoice(int Invoice, int FY) { DataTable table = new DataTable(); table = new AdminDataService().Get_Validate_VirtualInvoice(Invoice, FY).Tables[0]; return(table.Rows.Count > 0); }
public void OnGet() { AdminDataService IfaceAdmin = new AdminDataService(); PrizeNameList = IfaceAdmin.GetAllPrizesName(); PrizeValueList = IfaceAdmin.GetAllPrizesValue(); }
public IActionResult OnPostSubmit() { bool isAdmin = false; AdminDataService IAdminService = new AdminDataService(); TempData.Remove("IsLoggedIn"); if (UID == "" || UID == null) { DisplayMessage = $"Error Occured due to ID Field Empty."; return(Page()); } if (password == "" || password == null) { DisplayMessage = $"Error Occured due to Password Field Empty."; return(Page()); } if (IAdminService.CheckIsAdmin(UID, password)) { isAdmin = true; } if (isAdmin) { TempData.TryAdd("IsLoggedIn", "True"); return(RedirectToPage("./_Admin")); } else { DisplayMessage = "ID/Password Invalid"; return(Page()); } }
public static bool GetOrderNoAuthentication(string OrderNo) { DataTable table = new DataTable(); table = new AdminDataService().GetOrderNoAuthentication(OrderNo).Tables[0]; return((table.Rows.Count > 0) && (table.Rows[0]["OrderNo"].ToString() == OrderNo)); }
public static DataTable Get_AllocateKRA(string EmpCode, int FY, string Flag) { DataSet set = new AdminDataService().Get_AllocateKRA(EmpCode, FY, Flag); DataTable table = new DataTable(); return(set.Tables[0]); }
public static DataTable Get_TargetMaster(int FY) { DataSet set = new AdminDataService().Get_TargetMaster(FY); DataTable table = new DataTable(); return(set.Tables[0]); }
public static DataTable GetFinancialYear() { DataSet financialYear = new DataSet(); financialYear = new AdminDataService().GetFinancialYear(); DataTable table = new DataTable(); return(financialYear.Tables[0]); }
public static DataTable Get_RoleList() { DataSet set = new DataSet(); set = new AdminDataService().Get_RoleList(); DataTable table = new DataTable(); return(set.Tables[0]); }
public static DataTable Get_SectionList() { DataSet sectionMaster = new DataSet(); sectionMaster = new AdminDataService().GetSectionMaster(); DataTable table = new DataTable(); return(sectionMaster.Tables[0]); }
public static DataTable GetSDZonemaster() { DataSet sDZonemaster = new DataSet(); sDZonemaster = new AdminDataService().GetSDZonemaster(); DataTable table = new DataTable(); return(sDZonemaster.Tables[0]); }
public static DataTable GetBookMaster(string strChetanaCompanyName) { DataSet bookMaster = new DataSet(); bookMaster = new AdminDataService().GetBookMaster(strChetanaCompanyName); DataTable table = new DataTable(); return(bookMaster.Tables[0]); }
public static DataTable GetBookMaster() { DataSet bookMaster = new DataSet(); bookMaster = new AdminDataService().GetBookMaster(); DataTable table = new DataTable(); return(bookMaster.Tables[0]); }
public static DataTable GetAreaMaster() { DataSet areaMaster = new DataSet(); areaMaster = new AdminDataService().GetAreaMaster(); DataTable table = new DataTable(); return(areaMaster.Tables[0]); }
public static DataTable GetCustomerandTransporter1() { DataSet customerandTransporter = new DataSet(); customerandTransporter = new AdminDataService().GetCustomerandTransporter(); DataTable table = new DataTable(); return(customerandTransporter.Tables[0]); }
public static string get_Target_validateh_valid(int empid, string flag1) { DataTable table = new DataTable(); table = new AdminDataService().get_Target_validateh_valid(empid, flag1).Tables[0]; if (table.Rows.Count > 0) { return(table.Rows[0][0].ToString()); } return("not set!"); }
public static bool Get_DocumentNum_Authentication(int DocumentNo) { DataTable table = new DataTable(); table = new AdminDataService().Get_DocumentNum_Authentication(DocumentNo).Tables[0]; if (table.Rows.Count > 0) { return((table.Rows[0]["DocumentNo"].ToString() == Convert.ToString(DocumentNo)) && false); } return(true); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddAntiforgery(options => { options.HeaderName = "X-XSRF-TOKEN"; }); services.AddMvc(); AdminDataService.RegisterClassMaps(); DataService.RegisterClassMaps(); services.AddSingleton(typeof(QuoteService)); services.AddSingleton(typeof(CalendarService)); services.AddSingleton(typeof(PageService)); }
/// <summary> 初始化数据库 </summary> public static void InitializeDb() { InitializeAdminDb(); var adminService = new AdminDataService(); var dbVersion = adminService.Query <int>(GlobalKeys.DbVersion); if (dbVersion < Const.DbVersion) { //活动数据库 InitializeMeetingDb(); adminService.InsertOrUpdate(GlobalKeys.DbVersion, Const.DbVersion); } //VersionUpdateSql(); }
public static string Get_UserLogin(string EmpCode, string Password) { DataTable table = new DataTable(); table = new AdminDataService().Get_UserLogin(EmpCode, Password).Tables[0]; if (table.Rows.Count > 0) { if (table.Rows[0]["Password"].ToString() == Password) { return(table.Rows[0]["RoleID"].ToString()); } return(Convert.ToString(0)); } return(Convert.ToString(0)); }
public bool isDelete(string Flag, string Code) { bool flag = false; DataTable table = new DataTable(); table = new AdminDataService().Idv_check_Customer_for_delete(Flag, Code).Tables[0]; if (Convert.ToInt32(table.Rows[0][0].ToString()) <= 0) { flag = true; } else { flag = false; } return(false); }
public IActionResult OnPostDeletePrize() { TempData.Remove("Action"); TempData.Remove("Actiontype"); AdminDataService IfaceAdmin = new AdminDataService(); PrizeIdList = IfaceAdmin.GetPrizesId(); PrizeNameList = IfaceAdmin.GetAllPrizesName(); PrizeValueList = IfaceAdmin.GetAllPrizesValue(); if (PrizeIdList == null || PrizeNameList == null || PrizeValueList == null) { DisplayMessage = "Error Retrieving Prize List from Database. Connection" + " to database failed or no prizes exist yet."; } TempData["Action"] = "DeletePrize"; TempData["Actiontype"] = "Prize"; return(Page()); }
// Activates when Submit button on admin page is clicked. public IActionResult OnPostSubmit() { AdminDataService IfaceAdmin = new AdminDataService(); bool success = true; bool defaultCase = false; TempData.Keep("Action"); TempData.Keep("Actiontype"); // Basic error checking, Need to reset TempData as well if (UID == "" || UID == null) { DisplayMessage = $"Error Occurred due to ID/Prize Field Empty."; return(Page()); } if (Action == "" || Action == null) { DisplayMessage = $"Error Occurred due to Action not specified."; return(Page()); } if ((ChangeValue <= 0) && !(Action == "AddAccount" || Action == "CheckBalance" || Action == "DeletePrize" || Action == "DeleteAccount")) { DisplayMessage = $"Error Occurred due Value <= 0. Please enter a valid number."; PointMessage = $"Could not Complete Action, enter a positive number."; return(Page()); } if (Actiontype == "User") { Student student = new Student(); StudentDataService IfaceStudent = new StudentDataService(); if ((student = IfaceStudent.GetStudentCampusId(UID)) != null) { switch (Action) { case "AddAccount": success = IfaceAdmin.AddAccount(UID); PointMessage = "Student account added successfully."; break; case "CheckBalance": PointMessage = student.total_points.ToString(); break; case "IncreasePoint": success = IfaceAdmin.IncrementPoints(UID, ChangeValue); PointMessage = $" {student.first_name} {student.last_name} has {IfaceAdmin.CheckPoints(UID).ToString()} Points"; break; case "DecreasePoint": success = IfaceAdmin.DecrementPoints(UID, ChangeValue); break; case "SetPoint": success = IfaceAdmin.SetPoints(UID, ChangeValue); break; case "DeleteAccount": success = IfaceStudent.DeleteStudent(student.campus_id); break; default: DisplayMessage = $"Error Occurred due to Action variable undefined."; PointMessage = $"Could not Complete Action"; defaultCase = true; success = false; break; } if (success) { if (Action != "DeleteAccount") { PointMessage = $" {student.first_name} {student.last_name} has {IfaceAdmin.CheckPoints(UID).ToString()} Points"; } DisplayMessage = $"Transaction success with {student.first_name} {student.last_name}"; } else if (defaultCase) { // do Nothing } else { DisplayMessage = $"Action Failed due to database operation issue!"; PointMessage = $"Could not Complete Action"; } } else { switch (Action) { case "AddAccount": success = IfaceAdmin.AddAccount(UID); PointMessage = "Student account added successfully."; break; default: DisplayMessage = $"Error Occurred due to Student not found."; break; } } } else if (Actiontype == "Prize") { switch (Action) { case "SetPrize": success = IfaceAdmin.UpdatePrizePoints(UID, ChangeValue); break; case "AddPrize": success = IfaceAdmin.AddPrize(UID, ChangeValue); break; case "DeletePrize": success = IfaceAdmin.DeletePrize(UID); break; default: DisplayMessage = $"Error Occurred due to Action variable undefined."; defaultCase = true; success = false; break; } PrizeIdList = IfaceAdmin.GetPrizesId(); PrizeNameList = IfaceAdmin.GetAllPrizesName(); PrizeValueList = IfaceAdmin.GetAllPrizesValue(); if (success) { PointMessage = $"Transaction Success with Prize {UID}"; } else if (defaultCase) { //Do Nothing } else { DisplayMessage = $"Transaction Failed due to database operation issue! Check if Prize is valid."; } } else { DisplayMessage = $"Action Type Undefinied!"; } return(Page()); }
public static void HandleRequest(HttpListenerContext context) { try { HttpListenerRequest request = context.Request; string postData = new StreamReader(request.InputStream, Encoding.UTF8).ReadToEnd(); byte[] rbytes = HexStringToByteArray(postData); object recv = DeserializeObject(rbytes); Console.WriteLine("收到请求:" + recv); int id = int.Parse(request.Headers["UserId"]); HttpListenerResponse response = context.Response;//响应 string resp = "响应"; string responseBody = objecttostring(resp); // UsrInfoService UserInfoService UserInfoService = new UserInfoService() { UserId = id }; DeliveryDataService DeliveryDataService = new DeliveryDataService() { UserId = id }; ApplicationDataService ApplicationDataService = new ApplicationDataService() { UserId = id }; DonationDataService DonationDataService = new DonationDataService() { UserId = id }; AdminDataService AdminDataService = new AdminDataService() { UserId = id }; if (recv is LoginRequest loginRequest) { responseBody = objecttostring(UserInfoService.HandleLoginRequest(loginRequest)); } else if (recv is UserInfoRequest userInfoRequest) { responseBody = objecttostring(UserInfoService.HandleUserInfoRequest(userInfoRequest)); } else if (recv is RegisterRequest registerRequest) { responseBody = objecttostring(UserInfoService.HandleRegisterRequest(registerRequest)); } else if (recv is UserInfoModifyRequest userInfoModifyRequest) { responseBody = objecttostring(UserInfoService.HandleModifyRequest(userInfoModifyRequest)); } else if (recv is GetDonationListRequest getDonationListRequest) { responseBody = objecttostring(DonationDataService.HandleGetDonationListRequest(getDonationListRequest)); } else if (recv is GetDonationDetailRequest getDonationDetailRequest) { responseBody = objecttostring(DonationDataService.HandleGetDonationDetailRequest(getDonationDetailRequest)); } else if (recv is AvailableDonationMaterialRequest availableDonationMaterialRequest) { responseBody = objecttostring(DonationDataService.HandleAvailableDonationMaterialRequest(availableDonationMaterialRequest)); } else if (recv is NewDonationRequest newDonationRequest) { responseBody = objecttostring(DonationDataService.HandleNewDonationRequest(newDonationRequest)); } else if (recv is CancelDonationRequest cancelDonationRequest) { responseBody = objecttostring(DonationDataService.HandleCancelDonationRequest(cancelDonationRequest)); } // DeliveryDataService else if (recv is DeliveryListNumRequest deliveryListNumRequest) { responseBody = objecttostring(DeliveryDataService.HandleDeliveryListNumRequest(deliveryListNumRequest)); } else if (recv is DeliveryListRequest deliveryListRequest) { responseBody = objecttostring(DeliveryDataService.HandleDeliveryListRequest(deliveryListRequest)); } else if (recv is DeliveryMoveRequest deliveryMoveRequest) { responseBody = objecttostring(DeliveryDataService.HandleDeliveryMoveRequest(deliveryMoveRequest)); } else if (recv is DeliveryApplyRequest deliveryApplyRequest) { responseBody = objecttostring(DeliveryDataService.HandleDeliveryApplyRequest(deliveryApplyRequest)); } else if (recv is AvailableApplicationMaterialRequest availableApplicationMaterialRequest) { responseBody = objecttostring(ApplicationDataService.HandleAvailableApplicationMaterialRequest(availableApplicationMaterialRequest)); } else if (recv is GetApplicationDetailRequest getApplicationDetailRequest) { responseBody = objecttostring(ApplicationDataService.HandleGetApplicationDetailRequest(getApplicationDetailRequest)); } else if (recv is GetApplicationListRequest getApplicationListRequest) { responseBody = objecttostring(ApplicationDataService.HandleGetApplicationListRequest(getApplicationListRequest)); } else if (recv is NewApplicationRequest newApplicationRequest) { responseBody = objecttostring(ApplicationDataService.HandleNewApplicationRequest(newApplicationRequest)); } else if (recv is CancelApplicationRequest cancelApplicationRequest) { responseBody = objecttostring(ApplicationDataService.HandleCancelApplicationRequest(cancelApplicationRequest)); } else if (recv is ConfirmApplicationDoneRequest confirmApplicationDoneRequest) { responseBody = objecttostring(ApplicationDataService.HandleConfirmApplicationDoneRequest(confirmApplicationDoneRequest)); } // AdminDataService else if (recv is MaterialAuditAgreeRequest materialAuditAgreeRequest) { responseBody = objecttostring(AdminDataService.HandleMaterialAuditAgreeRequest(materialAuditAgreeRequest)); } else if (recv is MaterialAuditListRequest materialAuditListRequest) { responseBody = objecttostring(AdminDataService.HandleMaterialAuditListRequest(materialAuditListRequest)); } else if (recv is MaterialAuditRefuseRequest materialAuditRefuseRequest) { responseBody = objecttostring(AdminDataService.HandleMaterialAuditRefuseRequest(materialAuditRefuseRequest)); } else if (recv is SecondaryPasswordChangeRequest secondaryPasswordChangeRequest) { responseBody = objecttostring(AdminDataService.HandleSecondaryPasswordChangeRequest(secondaryPasswordChangeRequest)); } else { System.Diagnostics.Debug.Assert(false); } response.ContentLength64 = responseBody.Length; response.ContentType = "text/html"; //输出响应内容 Stream output = response.OutputStream; using (StreamWriter sw = new StreamWriter(output)) { sw.Write(responseBody); sw.Flush(); sw.Close(); } Console.WriteLine("响应结束"); } catch (Exception err) { Console.WriteLine(err.Message); } }