public ActionResult CreateTest(Test model) { int result = 0; string domainName = _configuration["DomainName"].ToSafeString(); if (!string.IsNullOrEmpty(domainName)) { result = BALUser.AddTest(model, domainName); } switch (result) { case -1: TempData["message"] = "Test Name already exists for same date."; TempData["IsSuccess"] = 0; break; case 0: TempData["message"] = "Something went wrong."; TempData["IsSuccess"] = 0; break; case 1: TempData["message"] = "Record successfully inserted."; TempData["IsSuccess"] = 1; break; case 2: TempData["message"] = "Record successfully updated."; TempData["IsSuccess"] = 1; break; } return(RedirectToAction("Index")); }
public IActionResult AthleteList(int?id) { AthleteModel model = new AthleteModel(); string message = string.Empty; try { model.athleteList = BALUser.GetAthletesByTypeId(id.ToSafeInt(), _configuration["DomainName"].ToSafeString()); model.TestId = id.ToSafeInt(); if (TempData["message"] != null) { message = TempData["message"].ToSafeString(); ViewBag.Message = message; if (TempData["IsSuccess"].ToSafeInt() == 0) { ViewBag.IsError = 1; } else { ViewBag.IsForgotPwdSucc = 1; } } } catch (System.Exception) { throw; } return(View(model)); }
private void BindCustomerDetails() { BALUser objBALUser = new BALUser(); try { gdvCustomer.PageSize = int.Parse(ViewState["ps"].ToString()); DataSet objds = objBALUser.GetUserDetails(0); Session["dt"] = objds.Tables[0]; if (objds.Tables[0].Rows.Count > 0) { string sortDirection = "ASC", sortExpression; if (ViewState["so"] != null) { sortDirection = ViewState["so"].ToString(); } if (ViewState["se"] != null) { sortExpression = ViewState["se"].ToString(); objds.Tables[0].DefaultView.Sort = sortExpression + " " + sortDirection; } gdvCustomer.DataSource = objds.Tables[0]; gdvCustomer.DataBind(); } else { gdvCustomer.DataSource = null; gdvCustomer.DataBind(); } } catch (Exception ex) { } }
protected void CreateUserButton_Click(object sender, EventArgs e) { BALUser balJoueur = new BALUser(); try { int returnValue = balJoueur.CreateUser(this.UserName.Text, this.Email.Text, this.Password.Text); if (returnValue > 0) { Page.RegisterClientScriptBlock("message", "<script>alert('Joueur is created successfully')</script>"); Session["User"] = this.UserName.Text; //binding(null); } else { Page.RegisterClientScriptBlock("message", "<script>alert('Incorrect User Inputs.')</script>"); } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
public void DeleteUser(BALUser obj) { query = "delete from [User] where UserId=" + obj.UserId; SqlCommand cmd = new SqlCommand(query,con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void UpdateUser(BALUser obj) { query = "update [User] set FirstName='" + obj.FirstName + "',LastName='" + obj.LastName + "',Address='" + obj.Address+"',Mobile='"+obj.Mobile+"',Gender='"+obj.Gender+"',Dob='"+obj.DateOfBirth+"',LoginId="+obj.LoginId+"where UserId="+obj.UserId; SqlCommand cmd = new SqlCommand(query,con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
private void InsertUpdateCustomer() { try { BALUser objBALUser = new BALUser(); UserEntity objUserEntity = new UserEntity(); objUserEntity.user_master_id = Convert.ToInt32(hfUserId.Value); objUserEntity.RoleId = Convert.ToInt32(dropUserType.SelectedValue); objUserEntity.LocationId = Convert.ToInt32(dropLocation.SelectedValue); objUserEntity.user_master_status = Convert.ToInt32(dropStatus.SelectedValue); //objUserEntity.IsLogin = bool.Parse(chkIsLogin.Text); objUserEntity.FirstName = txtFirstName.Text; objUserEntity.LastName = txtLastName.Text; objUserEntity.user_master_mobile = txtMobileNumber.Text; objUserEntity.user_master_land = txtLandLineNumber.Text; objUserEntity.user_master_mail = txtEmailId.Text; objUserEntity.user_master_name = ""; objUserEntity.user_master_desc = ""; objUserEntity.user_master_address = ""; objUserEntity.user_master_contact_person = ""; objUserEntity.user_master_link = ""; if (fuUserImage.HasFile) { string str = fuUserImage.FileName; fuUserImage.SaveAs(Server.MapPath("/Admin/CustomerImages/" + fuUserImage.FileName)); } else { labelError.Text = "Please Select Image"; return; } objUserEntity.user_master_logo = fuUserImage.FileName; objUserEntity.password = txtPassword.Text; objUserEntity.user_name = txtEmailId.Text; objUserEntity.password = txtConfirmPawd.Text; objUserEntity.user_master_created_by = Session["loginId"].ToString(); int nResult = objBALUser.InsertUpdateUser(objUserEntity); if (nResult == -1) { labelError.Text = "User already Exist"; } if (nResult > 0) { Response.Redirect("CustomerList.aspx", true); } } catch (Exception ex) { } }
public DataSet getuserprofile(BALUser obj) { query="select * from [User] a inner join Login b on a.LoginId=b.LoginId where a.LoginId="+obj.LoginId; DataSet ds = new DataSet(); SqlDataAdapter adp = new SqlDataAdapter(query, con); adp.Fill(ds); return ds; }
public void InsertUser(BALUser obj) { // query = "insert into User (FirstName,LastName,Address,Mobile,Gender,Dob,LoginId) values ('" + obj.FirstName + "','" + obj.LastName + "','" + obj.Address + "','" + obj.Mobile + "','" + obj.Gender + "','" + obj.DateOfBirth + "'," + obj.LoginId + ")"; query = "insert into [User] (FirstName,LastName,Address,Mobile,Gender,Dob,LoginId) values ('"+obj.FirstName+"','"+obj.LastName+"','"+obj.Address+"','"+obj.Mobile+"','"+obj.Gender+"','"+obj.DateOfBirth+"',"+obj.LoginId+")"; SqlCommand cmd = new SqlCommand(query,con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
protected void Page_Load(object sender, EventArgs e) { ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page); BALUser lclsUser = new BALUser(); lclsUser.UserName = Environment.UserName.ToString(); if (!IsPostBack) { BindCorporateMaster(); BindFacility(); } }
public IActionResult CreateNewAthlete(AthleteModel model) { int result = 0; string domainName = _configuration["DomainName"].ToSafeString(); if (!string.IsNullOrEmpty(domainName)) { AthleteTestMapping athleteTest = new AthleteTestMapping(); athleteTest.AthleteTestId = model.TestId.ToSafeInt(); athleteTest.AthleteId = model.AthleteId.ToSafeInt(); athleteTest.Distance = model.Distance; if (model.IsEditMode) { result = BALUser.AddAthlete(athleteTest, domainName, 1, model.MapId.ToSafeInt()); } else { result = BALUser.AddAthlete(athleteTest, domainName, 0, model.MapId.ToSafeInt()); } switch (result) { case -1: TempData["message"] = "Athlete already exists in this test."; TempData["IsSuccess"] = 0; break; case 0: TempData["message"] = "Something went wrong."; TempData["IsSuccess"] = 0; break; case 1: TempData["message"] = "Record successfully inserted."; TempData["IsSuccess"] = 1; break; case 2: TempData["message"] = "Record successfully updated."; TempData["IsSuccess"] = 1; break; } } return(RedirectToAction("AthleteList", new { id = model.TestId })); }
private void BindCorporateMaster() { BALUser lclsUser = new BALUser(); lclsUser.UserName = Environment.UserName.ToString(); DataSet ds = new DataSet(); //ds = lclsService.GetUserCredentials(lclsUser); //if (ds.Tables.Count > 0) //{ // if (ds.Tables[0].Rows.Count > 0) // { // //DataTable dt = new DataTable(); // lclsUser.UserID = Convert.ToInt64(ds.Tables[0].Rows[0]["UserID"].ToString()); // lclsUser.UserRoleID = Convert.ToInt64(ds.Tables[0].Rows[0]["RoleID"].ToString()); // } //} //if (lclsUser.UserRoleID == 1) //{ // Search Drop Down drpcorp.DataSource = lclsService.GetCorporateMaster().ToList(); drpcorp.DataTextField = "CorporateName"; drpcorp.DataValueField = "CorporateID"; drpcorp.DataBind(); //drpcorsearch.Items.Insert(0, lst); //drpcorsearch.SelectedIndex = 0; //} //else //{ // List<BALUser> lstfacility = new List<BALUser>(); // lstfacility = lclsService.GetCorporateFacilityByUserID(lclsUser.UserID).ToList(); // drpcorp.DataSource = lstfacility.Select(a => new { a.CorporateID, a.CorporateName }).Distinct(); // drpcorp.DataTextField = "CorporateName"; // drpcorp.DataValueField = "CorporateID"; // drpcorp.DataBind(); //} ListItem lst = new ListItem(); lst.Value = "0"; lst.Text = "--Select Corporate--"; drpcorp.Items.Insert(0, lst); drpcorp.SelectedIndex = 0; }
private void DoAutoLogin() { InventoryServiceClient lclsService = new InventoryServiceClient(); BALUser lcluser = new BALUser(); //bool IsUserExist = lclsService.IsUserExist(txtUsername.Text, txtPassword.Text); lcluser.UserName = Context.User.Identity.Name.ToString(); DataSet ds = new DataSet(); ds = lclsService.GetUserCredentials(lcluser); if (ds.Tables.Count > 0) { Response.Redirect("Login.aspx"); } else { Response.Redirect(@"Account\SignOut.aspx"); } }
public IActionResult Index() { List <Test> model = BALUser.GetTestList(_configuration["DomainName"].ToSafeString()); string message = string.Empty; if (TempData["message"] != null) { message = TempData["message"].ToSafeString(); ViewBag.Message = message; if (TempData["IsSuccess"].ToSafeInt() == 0) { ViewBag.IsError = 1; } else { ViewBag.IsForgotPwdSucc = 1; } } return(View(model)); }
private void BindFacility() { BALUser lclsUser = new BALUser(); lclsUser.UserName = Environment.UserName.ToString(); DataSet ds = new DataSet(); //ds = lclsService.GetUserCredentials(lclsUser); //if (ds.Tables.Count > 0) //{ // if (ds.Tables[0].Rows.Count > 0) // { // //DataTable dt = new DataTable(); // lclsUser.UserID = Convert.ToInt64(ds.Tables[0].Rows[0]["UserID"].ToString()); // lclsUser.UserRoleID = Convert.ToInt64(ds.Tables[0].Rows[0]["RoleID"].ToString()); // } //} //if (lclsUser.UserRoleID == 1) //{ drpfacility.DataSource = lclsService.GetCorporateFacility(Convert.ToInt64(drpcorp.SelectedValue)).Where(a => a.IsActive == true).ToList(); drpfacility.DataTextField = "FacilityDescription"; drpfacility.DataValueField = "FacilityID"; drpfacility.DataBind(); //} //else //{ // drpfacility.DataSource = lclsService.GetCorporateFacilityByUserID(lclsUser.UserID).Where(a => a.CorporateName == drpcorp.SelectedItem.Text).ToList(); // drpfacility.DataTextField = "FacilityName"; // drpfacility.DataValueField = "FacilityID"; // drpfacility.DataBind(); //} ListItem lst = new ListItem(); lst.Value = "0"; lst.Text = "--Select Facility--"; drpfacility.Items.Insert(0, lst); drpfacility.SelectedIndex = 0; }
public IActionResult CreateAthlete(int?testId, int?athleteId) { AthleteModel model = new AthleteModel(); Test test = new Test(); AthleteTestMapping athleteTestMapping = new AthleteTestMapping(); string domainName = _configuration["DomainName"].ToSafeString(); if (!string.IsNullOrEmpty(domainName)) { if (testId.HasValue && athleteId.ToSafeInt() == 0) { model.TestId = testId.ToSafeInt(); model.userList = BALUser.GetUserListByRoleId((int)Enums.UserRole.Athlete, domainName); test = BALUser.GetTestTypeByTestId(testId.ToSafeInt(), domainName); model.TestName = test.TestName.ToSafeString() + " " + test.TestDate.ToString("yyyy/MM/dd"); model.IsEditMode = false; } else { model.TestId = testId.ToSafeInt(); model.userList = BALUser.GetUserListByRoleId((int)Enums.UserRole.Athlete, domainName); test = BALUser.GetTestTypeByTestId(testId.ToSafeInt(), domainName); model.TestName = test.TestName.ToSafeString() + " " + test.TestDate.ToString("yyyy/MM/dd"); athleteTestMapping = BALUser.GetAthlete(athleteId.ToSafeInt(), domainName); if (athleteTestMapping != null) { model.AthleteId = athleteTestMapping.AthleteId.ToSafeInt(); model.Distance = athleteTestMapping.Distance; model.IsEditMode = true; model.MapId = athleteTestMapping.MapId.ToSafeInt(); } } } return(PartialView("~/Views/Home/AddAthlete.cshtml", model)); }
public IActionResult DeleteTest(AthleteModel model) { int result = 0; string domainName = _configuration["DomainName"].ToSafeString(); if (!string.IsNullOrEmpty(domainName)) { result = BALUser.DeleteTest(model.TestId.ToSafeInt(), domainName); switch (result) { case 0: TempData["message"] = "Something went wrong."; TempData["IsSuccess"] = 0; break; case 1: TempData["message"] = "Record successfully deleted."; TempData["IsSuccess"] = 1; break; } } return(RedirectToAction("Index")); }
//private void BindFacility() //{ // drpfacility.DataSource = lclsService.GetFacility().ToList(); // drpfacility.DataTextField = "FacilityName"; // drpfacility.DataValueField = "FacilityID"; // drpfacility.DataBind(); // ListItem lst = new ListItem(); // lst.Value = "0"; // lst.Text = "--Select Facility--"; // drpfacility.Items.Insert(0, lst); // drpfacility.SelectedIndex = 0; //} protected void btnlogin_Click(object sender, EventArgs e) { InventoryServiceClient lclsService = new InventoryServiceClient(); BALUser lclsUser = new BALUser(); lclsUser.FacilityID = Convert.ToInt64(drpfacility.SelectedValue); lclsUser.UserName = txtemail.Text; lclsUser.Password = txtpwd.Text; lclsUser.CorporateID = Convert.ToInt64(drpcorp.SelectedValue); List <GetLoginDetails> lstloginuser = lclsService.GetLoginDetails(lclsUser).ToList(); if (lstloginuser.Count != 0) { defaultPageControls.UserId = lstloginuser[0].UserID; defaultPageControls.UserName = lstloginuser[0].UserName; defaultPageControls.FacilityID = Convert.ToInt64(lstloginuser[0].FacilityID); defaultPageControls.RoleID = Convert.ToInt64(lstloginuser[0].RoleID); defaultPageControls.UserRoleName = lstloginuser[0].UserRoleName; defaultPageControls.CorporateID = Convert.ToInt64(lstloginuser[0].CorporateID); List <GetUserPagePermission> lstPermission = lclsService.GetLoginPermissionDetails(defaultPageControls.RoleID).ToList(); for (var i = 0; i < lstPermission.Count; i++) { switch (Convert.ToInt32(lstPermission[i].MainMenuID)) { case 1: switch (Convert.ToInt32(lstPermission[i].SubMenuID)) { case 1: defaultPageControls.Req_MedicalSuppliesPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Req_MedicalSuppliesPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 2: defaultPageControls.Req_WorkOrServicePage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Req_WorkOrServicePage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 3: defaultPageControls.Req_MachinePartsPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Req_MachinePartsPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 4: defaultPageControls.Req_RequestITPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Req_RequestITPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 5: defaultPageControls.CapitalItemRequest_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.CapitalItemRequest_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; } break; case 2: switch (Convert.ToInt32(lstPermission[i].SubMenuID)) { case 5: defaultPageControls.Rec_MedicalSuppliesPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Rec_MedicalSuppliesPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 6: defaultPageControls.Rec_WorkOrServicePage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Rec_WorkOrServicePage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 7: defaultPageControls.Rec_MachinePartsPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Rec_MachinePartsPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 8: defaultPageControls.CapitalReceiving_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.CapitalReceiving_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 30: defaultPageControls.ITReceiving_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.ITReceiving_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; } break; case 3: switch (Convert.ToInt32(lstPermission[i].SubMenuID)) { case 9: defaultPageControls.StocksOrInventory_Ending_Page_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.StocksOrInventory_Ending_Page_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 10: defaultPageControls.StocksOrInventory_Daily_Page_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.StocksOrInventory_Daily_Page_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; } break; case 4: switch (Convert.ToInt32(lstPermission[i].SubMenuID)) { case 11: defaultPageControls.CurrencyPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.CurrencyPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 12: defaultPageControls.CorporatePage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.CorporatePage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 13: defaultPageControls.FacilityPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.FacilityPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 14: defaultPageControls.FacilityReligionPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.FacilityReligionPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 15: defaultPageControls.ItemCategoryPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.ItemCategoryPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 16: defaultPageControls.MedicalSuppliesPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.MedicalSuppliesPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 17: defaultPageControls.UomMaster_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.UomMaster_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 18: defaultPageControls.AddUserPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.AddUserPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 19: defaultPageControls.UserPermission_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.UserPermission_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 20: defaultPageControls.VendorPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.VendorPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; //case 21: // defaultPageControls.VendorFacilityActPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); // defaultPageControls.VendorFacilityActPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); // break; case 22: defaultPageControls.VendorItemMap_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.VendorItemMap_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 23: defaultPageControls.FacilityItemMap_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.FacilityItemMap_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 24: defaultPageControls.VendorFacilityActPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.VendorFacilityActPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 25: defaultPageControls.VendorOrderDue_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.VendorOrderDue_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 26: defaultPageControls.FacilitySuppliesMap_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.FacilitySuppliesMap_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 27: defaultPageControls.MachineMaster_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.MachineMaster_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 28: defaultPageControls.CorpEquipmentMap_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.CorpEquipmentMap_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; } break; case 5: switch (Convert.ToInt32(lstPermission[i].SubMenuID)) { case 26: defaultPageControls.TransferInPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.TransferInPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 27: defaultPageControls.TransferOutPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.TransferOutPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); defaultPageControls.TransferOutPage_Email = Convert.ToBoolean(lstPermission[i].IsEmailNotification); break; case 28: defaultPageControls.TransferHistoryPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.TransferHistoryPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; } break; case 6: switch (Convert.ToInt32(lstPermission[i].SubMenuID)) { case 28: defaultPageControls.VendorOrderDueRemainder_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.VendorOrderDueRemainder_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; } break; case 7: switch (Convert.ToInt32(lstPermission[i].SubMenuID)) { case 1: defaultPageControls.CapitalOrder_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.CapitalOrder_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 2: defaultPageControls.Req_RequestITPOPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Req_RequestITPOPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 3: defaultPageControls.Req_POServicePage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.Req_POServicePage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 4: defaultPageControls.MachinePartsOrder_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.MachinePartsOrder_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; case 5: defaultPageControls.MedicalSuppliesOrder_Edit = Convert.ToBoolean(lstPermission[i].IsEdit); defaultPageControls.MedicalSuppliesOrder_View = Convert.ToBoolean(lstPermission[i].IsViewOnly); break; } break; } } Session["Permission"] = defaultPageControls; Response.Redirect("Dashboard.aspx"); } else { lblerror.Visible = true; lblerror.Text = "Invalid UserName and Password"; } }
private string UKZNCreateInvoice(string FileNo) { try { decimal TotalAmount = 0; DataSet objDs = objBALFileManager.GetQuotationMasterByFileNo(FileNo); string strMessage = string.Empty; int ItemInvoiceNo = 0; if (objDs.Tables[0].Rows.Count > 0) { int CreatedBy = Convert.ToInt32(Session["loginId"]); int RoleId = Convert.ToInt32(Session["role_id"]); int CompanyId = Convert.ToInt32(Session["CompanyId"]); string QuotationRefNo = objDs.Tables[0].Rows[0]["QuotationMasterId"].ToString(); DataSet objDsQut = _objBOQutation.GetQuotationMasterDetailsWithRefNo(Convert.ToInt32(QuotationRefNo), RoleId, CompanyId, CreatedBy, ""); TravelRequestProcess objTravelRequest = new TravelRequestProcess(); List <UKZNInoviceDetails> LstObj = new List <UKZNInoviceDetails>(); int FlightRequestID = 0; int HotelRequestId = 0; int CabRequestId = 0; if (objDsQut.Tables[0].Rows.Count > 0)// Flight Invoice { foreach (GridViewRow row in gdvFlightBookings.Rows) { CheckBox chk = row.FindControl("chkSelect") as CheckBox; if (chk != null && chk.Checked) { foreach (DataRow QuotationRow in objDsQut.Tables[0].Rows) { ItemInvoiceNo = ItemInvoiceNo + 1; UKZNInoviceDetails objF = new UKZNInoviceDetails(); objF.accountnumber = QuotationRow["AccountCode"].ToString(); objF.uniquerequestid = "F_" + QuotationRow["FlightRequestId"].ToString(); // QuotationRow["Fromcode"].ToString(); objF.invoiceitemnumber = ItemInvoiceNo.ToString(); // QuotationRow["FlightRequestId"].ToString();//"F_" + QuotationRow["FlightRequestId"].ToString(); objF.invoiceitemdescription = "Flight Item invoice created for file no" + FileNo; objF.invoiceitemnote = "not paid"; objF.fullyprocessedyn = "N"; //QuotationRow["Fromcode"].ToString(); objF.alreadypaidyn = "N"; // QuotationRow["Fromcode"].ToString(); objF.itemamountincvat = QuotationRow["TotalPrice"].ToString(); TotalAmount = TotalAmount + Convert.ToDecimal(QuotationRow["TotalPrice"].ToString()); objF.commentstmc = "Flight invoice created" + QuotationRow["FlightRequestId"].ToString(); objF.itemvatamount = _objBoutility.CalculateVat(Convert.ToDecimal(objF.itemamountincvat), _decVarPercentage).ToString(); FlightRequestID = Convert.ToInt32(QuotationRow["FlightRequestId"]); LstObj.Add(objF); } } } } if (objDsQut.Tables[1].Rows.Count > 0)// Hotel Invoice { foreach (DataRow QuotationRow in objDsQut.Tables[1].Rows) { foreach (GridViewRow row in gdvHotelBooking.Rows) { CheckBox chk = row.FindControl("chkSelect") as CheckBox; if (chk != null && chk.Checked) { ItemInvoiceNo = ItemInvoiceNo + 1; UKZNInoviceDetails objH = new UKZNInoviceDetails(); objH.accountnumber = QuotationRow["AccountCode"].ToString(); objH.uniquerequestid = "A_" + QuotationRow["HotelRequestId"].ToString(); // QuotationRow["Fromcode"].ToString(); objH.invoiceitemdescription = "Hotel Item Invoice Created for file no" + FileNo; objH.invoiceitemnumber = ItemInvoiceNo.ToString(); //"A_" + QuotationRow["HotelRequestId"].ToString(); objH.invoiceitemnote = "not paid"; objH.fullyprocessedyn = "N"; //QuotationRow["Fromcode"].ToString(); objH.alreadypaidyn = "N"; // QuotationRow["Fromcode"].ToString(); objH.itemamountincvat = QuotationRow["TotalFee"].ToString(); objH.commentstmc = "Hotel Invoice Created" + QuotationRow["HotelRequestId"].ToString(); objH.itemvatamount = _objBoutility.CalculateVat(Convert.ToDecimal(objH.itemamountincvat), _decVarPercentage).ToString(); TotalAmount = TotalAmount + Convert.ToDecimal(QuotationRow["TotalFee"].ToString()); HotelRequestId = Convert.ToInt32(QuotationRow["HotelRequestId"]); LstObj.Add(objH); } } } } if (objDsQut.Tables[3].Rows.Count > 0)// Hotel Invoice { foreach (DataRow QuotationRow in objDsQut.Tables[3].Rows) { foreach (GridViewRow row in gvCarBookings.Rows) { CheckBox chk = row.FindControl("chkSelect") as CheckBox; if (chk != null && chk.Checked) { ItemInvoiceNo = ItemInvoiceNo + 1; UKZNInoviceDetails objc = new UKZNInoviceDetails(); objc.accountnumber = "30031"; objc.uniquerequestid = "C_" + QuotationRow["CarDescId"].ToString(); // QuotationRow["Fromcode"].ToString(); objc.invoiceitemdescription = "Car Item Invoice Created for file no" + FileNo; objc.invoiceitemnumber = ItemInvoiceNo.ToString(); //"A_" + QuotationRow["HotelRequestId"].ToString(); objc.invoiceitemnote = "not paid"; objc.fullyprocessedyn = "N"; //QuotationRow["Fromcode"].ToString(); objc.alreadypaidyn = "N"; // QuotationRow["Fromcode"].ToString(); objc.itemamountincvat = QuotationRow["TotalPrice"].ToString(); objc.commentstmc = "Hotel Invoice Created" + QuotationRow["CarDescId"].ToString(); objc.itemvatamount = _objBoutility.CalculateVat(Convert.ToDecimal(objc.itemamountincvat), _decVarPercentage).ToString(); TotalAmount = TotalAmount + Convert.ToDecimal(QuotationRow["TotalPrice"].ToString()); CabRequestId = Convert.ToInt32(QuotationRow["CarDescId"]); LstObj.Add(objc); } } } } if (TotalAmount > 0) { string Invocie = "0"; if (objDsQut.Tables[2].Rows.Count > 0) { BALUser objBALUer = new BALUser(); int InvoiceNo = objBALUer.GenerateInvocieNo(); Invocie = "INV" + InvoiceNo.ToString("000"); objTravelRequest.supplierno = _strUKZNsupplierno; objTravelRequest.invoicenumber = objDsQut.Tables[2].Rows[0]["QuotationRefNo"].ToString().Replace("QT", "IN_"); // Invocie; objTravelRequest.totamountincvat = TotalAmount.ToString(); // objDsQut.Tables[2].Rows[0]["TripAmount"].ToString(); objTravelRequest.invoicedate = DateTime.Now.ToString("dd-MMM-yyyy").ToUpper(); objTravelRequest.invoicedescription = "Invoice order no " + objDsQut.Tables[2].Rows[0]["ukzn_orderno"].ToString(); objTravelRequest.ordernumber = objDsQut.Tables[2].Rows[0]["ukzn_orderno"].ToString(); objTravelRequest.costcentre = objDsQut.Tables[2].Rows[0]["cost_center"].ToString(); } objTravelRequest.ListObjectUKZNInvoice = LstObj; strMessage = _objUKZNTravelRequest.validateinvoice(objTravelRequest); if (strMessage == "Success") { objBALFileManager.UpdateFileMaster(FileNo, Invocie); lblMsg.Text = _objBoutility.ShowMessage("succcess", "info ", "Invoice created in integrator"); } else { objBALFileManager.UpdateFileMaster(FileNo, strMessage); lblMsg.Text = _objBoutility.ShowMessage("succcess", "info ", strMessage); } } else { lblMsg.Text = _objBoutility.ShowMessage("danger", "Error ", "Please select item"); } } else { lblMsg.Text = _objBoutility.ShowMessage("danger", "Error ", "No order find with this order no."); } return(strMessage); } catch (Exception ex) { lblMsg.Text = _objBoutility.ShowMessage("danger", "Error ", ex.Message); return(""); } }