public void Delete(EUserCompany userCompany) { DaCommand command = new DaCommand("UserCompanyDelete"); command.AddInParameter("@CodeUser", DbType.String, userCompany.CodeUser); command.AddInParameter("@CodeCompany", DbType.String, userCompany.CodeCompany); ExecuteNonQuery(command); }
public DataRow Select(EUserCompany userCompany) { DaCommand command = new DaCommand("UserCompanySelect"); command.AddInParameter("@CodeUser", DbType.String, userCompany.CodeUser); command.AddInParameter("@CodeCompany", DbType.String, userCompany.CodeCompany); return(ExecuteDataRow(command)); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ArrayList list = new ArrayList(); foreach (RepeaterItem i in Repeater.Items) { CheckBox cb = (CheckBox)i.FindControl("ItemSelect"); if (cb.Checked) { ECompany o = new ECompany(); WebFormUtils.GetKeys(db, o, cb); list.Add(o); } } foreach (ECompany o in list) { if (ECompany.db.select(dbConn, o)) { DBFilter empPosFilter = new DBFilter(); empPosFilter.add(new Match("CompanyID", o.CompanyID)); empPosFilter.add("empid", true); ArrayList empPosList = EEmpPositionInfo.db.select(dbConn, empPosFilter); if (empPosList.Count > 0) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_CODE_USED_BY_EMPLOYEE, new string[] { HROne.Common.WebUtility.GetLocalizedString("Company Code"), o.CompanyCode })); foreach (EEmpPositionInfo empPos in empPosList) { EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = empPos.EmpID; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { errors.addError("- " + empInfo.EmpNo + ", " + empInfo.EmpEngFullName); } else { EEmpPositionInfo.db.delete(dbConn, empPos); } } errors.addError(HROne.Translation.PageErrorMessage.ERROR_ACTION_ABORT); } else { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, o); EUserCompany.DeleteCompanyForAllUsers(dbConn, o.CompanyID); DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", o.CompanyID)); ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMapFilter); WebUtils.EndFunction(dbConn); } } } loadData(info, db, Repeater); }
public void Delete() { bool result = false; BUserCompany bUserCompany = new BUserCompany(); EUserCompany eUserCompany = new EUserCompany(); EUserCompany insertedUserCompany = new EUserCompany(); EUserCompany deletedUserCompany = new EUserCompany(); BCorporation bCorporation = new BCorporation(); ECorporation eCorporation = new ECorporation(); BCompany bCompany = new BCompany(); ECompany eCompany = new ECompany(); BUser bUser = new BUser(); EUser eUser = new EUser(); TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew); eCorporation.CodeCorporation = Aleatory.GetString(2); eCorporation.Name = Aleatory.GetString(15); eCorporation.State = Aleatory.GetShort(); eCorporation.Audit.UserRegister = Aleatory.GetString(8); bCorporation.Insert(eCorporation); eCompany.CodeCompany = Aleatory.GetString(2); eCompany.CodeCorporation = eCorporation.CodeCorporation; eCompany.Ruc = Aleatory.GetString(11); eCompany.LongName = Aleatory.GetString(15); eCompany.State = Aleatory.GetShort(); eCompany.Audit.UserRegister = Aleatory.GetString(8); bCompany.Insert(eCompany); eUser.CodeUser = Aleatory.GetString(8); eUser.Name = Aleatory.GetString(8); eUser.Password = Aleatory.GetString(8); eUser.State = Aleatory.GetShort(); eUser.Audit.UserRegister = Aleatory.GetString(8); bUser.Insert(eUser); eUserCompany.CodeUser = eUser.CodeUser; eUserCompany.CodeCompany = eCompany.CodeCompany; bUserCompany.Insert(eUserCompany); insertedUserCompany = bUserCompany.Select(eUserCompany); if (insertedUserCompany != null) { bUserCompany.Delete(eUserCompany); } deletedUserCompany = bUserCompany.Select(eUserCompany); if (deletedUserCompany == null) { result = true; } Assert.IsTrue(result); }
public EUserCompany Select(EUserCompany userCompany) { EUserCompany result = null; DataRow row = dUserCompany.Select(userCompany); if (row != null) { result = new EUserCompany(row); } return(result); }
//=====================================================GETS ABOVE===================================================== #region AddCompanyAsync public async Task <EUserCompany> AddCompanyAsync(EUserCompany e) { using var context = new SMySQLContext(); //var ecompany = context.Companies.Where(x => x.Name == e.CompanyName).FirstOrDefault(); //e.CompanyId = ecompany.Id; e.ModificationDateUTC = DateTime.UtcNow; e.CreationDateUTC = DateTime.UtcNow; var result = await context.UserCompanies.AddAsync(e); await context.SaveChangesAsync(); return(result.Entity); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ECompany c = new ECompany(); c.CompanyID = CurID; if (ECompany.db.select(dbConn, c)) { DBFilter empPosFilter = new DBFilter(); empPosFilter.add(new Match("CompanyID", c.CompanyID)); empPosFilter.add("empid", true); ArrayList empPosList = EEmpPositionInfo.db.select(dbConn, empPosFilter); if (empPosList.Count > 0) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_CODE_USED_BY_EMPLOYEE, new string[] { HROne.Common.WebUtility.GetLocalizedString("Company Code"), c.CompanyCode })); foreach (EEmpPositionInfo empPos in empPosList) { EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = empPos.EmpID; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { errors.addError("- " + empInfo.EmpNo + ", " + empInfo.EmpEngFullName); } else { EEmpPositionInfo.db.delete(dbConn, empPos); } } errors.addError(HROne.Translation.PageErrorMessage.ERROR_ACTION_ABORT); return; } else { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, c); EUserCompany.DeleteCompanyForAllUsers(dbConn, c.CompanyID); DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", c.CompanyID)); ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMapFilter); WebUtils.EndFunction(dbConn); } } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Company_List.aspx"); }
public void DeleteByUser(EUser eUser) { EUserCompany eUserCompany; List <ECompany> listECompanies; short listCount; using (TransactionScope ts = new TransactionScope()) { listECompanies = SelectByUser(eUser); listCount = Convert.ToInt16(listECompanies.Count); for (short index = 0; index <= listCount - 1; index++) { eUserCompany = new EUserCompany(); eUserCompany.CodeUser = eUser.CodeUser; eUserCompany.CodeCompany = listECompanies[index].CodeCompany; Delete(eUserCompany); } ts.Complete(); } }
public async Task <EUserCompany> AddCompany(EUserCompany eUserCompany) { ClientDefines.Loading = true; HttpRequestMessage req = new HttpRequestMessage(HttpMethod.Post, $"api/v1/SUsersCompanies/AddCompany"); req.Headers.Add("Authorization", $"bearer {ClientDefines.Token}"); req.Content = new StringContent(JsonConvert.SerializeObject(eUserCompany), Encoding.UTF8, "application/json"); var response = await httpClient.SendAsync(req); ClientDefines.Loading = false; if (response.StatusCode == System.Net.HttpStatusCode.Unauthorized) { throw new UnauthorizedAccessException(); } response.EnsureSuccessStatusCode(); string responseBody = await response.Content.ReadAsStringAsync(); EUserCompany result = JsonConvert.DeserializeObject <EUserCompany>(responseBody); return(result); }
public void UpdateByUser(EUser eUser) { EUserCompany eUserCompany; List <string> Companies; short listCount; using (TransactionScope ts = new TransactionScope()) { DeleteByUser(eUser); Companies = eUser.Companies; listCount = Convert.ToInt16(Companies.Count); for (short index = 0; index <= listCount - 1; index++) { eUserCompany = new EUserCompany(); eUserCompany.CodeUser = eUser.CodeUser; eUserCompany.CodeCompany = Companies[index]; Insert(eUserCompany); } ts.Complete(); } }
public async Task <ActionResult <EUserCompany> > AddCompany([FromBody] EUserCompany eUserCompany) { var e = await service.AddCompanyAsync(eUserCompany); return(Ok(e)); }
public void Delete(EUserCompany userCompany) { dUserCompany.Delete(userCompany); }
public void Insert(EUserCompany userCompany) { dUserCompany.Insert(userCompany); }
protected void Save_Click(object sender, EventArgs e) { ECompany c = new ECompany(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (!AppUtils.checkDuplicate(dbConn, db, c, errors, "CompanyCode")) { return; } if (WebUtils.TotalActiveCompany(dbConn, c.CompanyID) >= WebUtils.productLicense(Session).NumOfCompanies) { errors.addError(string.Format(PageErrorMessage.ERROR_MAX_LICENSE_LIMITCH_REACH, new string[] { WebUtils.productLicense(Session).NumOfCompanies + " " + HROne.Common.WebUtility.GetLocalizedString("Company") })); } if (!errors.isEmpty()) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE); if (CurID < 0) { // Utils.MarkCreate(Session, c); db.insert(dbConn, c); EUserCompany.InsertCompanyForUser(dbConn, WebUtils.GetCurUser(Session).UserID, c.CompanyID); CurID = c.CompanyID; // url = Utils.BuildURL(-1, CurID); } else { // Utils.Mark(Session, c); db.update(dbConn, c); } ArrayList selectedList = new ArrayList(); ArrayList unselectedList = new ArrayList(); foreach (RepeaterItem i in companyBankAccountRepeater.Items) { CheckBox cb = (CheckBox)i.FindControl("ItemSelect"); ECompanyBankAccount o = new ECompanyBankAccount(); WebFormUtils.GetKeys(ECompanyBankAccount.db, o, cb); if (cb.Checked) { selectedList.Add(o); } else { unselectedList.Add(o); } } foreach (ECompanyBankAccount o in selectedList) { DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", CurID)); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", o.CompanyBankAccountID)); ArrayList companyBankAccountMapList = ECompanyBankAccountMap.db.select(dbConn, companyBankAccountMapFilter); if (companyBankAccountMapList.Count == 0) { ECompanyBankAccountMap companyBankAccountMap = new ECompanyBankAccountMap(); companyBankAccountMap.CompanyID = CurID; companyBankAccountMap.CompanyBankAccountID = o.CompanyBankAccountID; ECompanyBankAccountMap.db.insert(dbConn, companyBankAccountMap); } } foreach (ECompanyBankAccount o in unselectedList) { DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", CurID)); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", o.CompanyBankAccountID)); ArrayList companyBankAccountMapList = ECompanyBankAccountMap.db.select(dbConn, companyBankAccountMapFilter); if (companyBankAccountMapList.Count != 0) { foreach (ECompanyBankAccountMap companyBankAccountMap in companyBankAccountMapList) { ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMap); } } } WebUtils.EndFunction(dbConn); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Company_View.aspx?CompanyID=" + CurID); }
protected void Save_Click(object sender, EventArgs e) { EUser c = new EUser(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (Password.Text.Equals("")) { errors.addError("Password", HROne.Translation.PageErrorMessage.ERROR_FIELD_REQUIRED); return; } if (!Password2.Text.Equals(Password.Text)) { errors.addError("Password", HROne.Translation.PageErrorMessage.ERROR_PASSWORD_NOT_MATCH); return; } if (!Password.Text.Equals(NO_CHANGE_PASSWORD)) { c.UserPassword = HROne.CommonLib.Hash.PasswordHash(Password.Text); } else if (CurID < 0) { c.UserPassword = HROne.CommonLib.Hash.PasswordHash(string.Empty); } if (c.UserAccountStatus.Equals("A")) { if (WebUtils.TotalActiveUser(dbConn, c.UserID) >= WebUtils.productLicense(Session).NumOfUsers) { errors.addError(string.Format(PageErrorMessage.ERROR_MAX_LICENSE_LIMITCH_REACH, new string[] { WebUtils.productLicense(Session).NumOfUsers + " " + HROne.Common.WebUtility.GetLocalizedString("User") })); return; } } ArrayList newCompanyList = WebUtils.SelectedRepeaterItemToBaseObjectList(ECompany.db, Companies, "ItemSelect"); ArrayList newUserGroupList = WebUtils.SelectedRepeaterItemToBaseObjectList(EUserGroup.db, UserGroups, "ItemSelect"); ArrayList newRankList = WebUtils.SelectedRepeaterItemToBaseObjectList(ERank.db, Ranks, "ItemSelect"); // Start 0000069, KuangWei, 2014-08-26 ArrayList newPayGroupList = WebUtils.SelectedRepeaterItemToBaseObjectList(EPayrollGroup.db, PayGroups, "ItemSelect"); // End 0000069, KuangWei, 2014-08-26 if (WebUtils.GetCurUser(Session).UsersCannotCreateUsersWithMorePermission) { if (c.UsersCannotCreateUsersWithMorePermission == false) { errors.addError(PageErrorMessage.ERROR_INVALID_PERMISSION); return; } // Start 0000069, KuangWei, 2014-08-26 else if (!c.IsAllowSubmitPermission(dbConn, WebUtils.GetCurUser(Session).UserID) || !EUser.IsAllowSubmitPermission(dbConn, WebUtils.GetCurUser(Session).UserID, newCompanyList, newUserGroupList, newRankList, newPayGroupList) // End 0000069, KuangWei, 2014-08-26 ) { errors.addError(PageErrorMessage.ERROR_INVALID_PERMISSION); return; } // do nothing } WebUtils.StartFunction(Session, FUNCTION_CODE); if (CurID < 0) { // Utils.MarkCreate(Session, c); c.UserChangePasswordDate = AppUtils.ServerDateTime(); db.insert(dbConn, c); CurID = c.UserID; // url = Utils.BuildURL(-1, CurID); } else { // Utils.Mark(Session, c); db.update(dbConn, c); } { DBFilter notUserGroupAccess = new DBFilter(); notUserGroupAccess.add(new Match("UserID", c.UserID)); foreach (EUserGroup userGroup in newUserGroupList) { DBFilter filter = new DBFilter(); filter.add(new Match("UserID", c.UserID)); filter.add(new Match("UserGroupID", userGroup.UserGroupID)); if (EUserGroupAccess.db.count(dbConn, filter) <= 0) { EUserGroupAccess o = new EUserGroupAccess(); o.UserID = c.UserID; o.UserGroupID = userGroup.UserGroupID; EUserGroupAccess.db.insert(dbConn, o); } notUserGroupAccess.add(new Match("UserGroupID", "<>", userGroup.UserGroupID)); } ArrayList unselectedUserGroupAccessList = EUserGroupAccess.db.select(dbConn, notUserGroupAccess); foreach (EUserGroupAccess userGroupAccess in unselectedUserGroupAccessList) { EUserGroupAccess.db.delete(dbConn, userGroupAccess); } } { DBFilter notUserCompany = new DBFilter(); notUserCompany.add(new Match("UserID", c.UserID)); foreach (ECompany company in newCompanyList) { DBFilter filter = new DBFilter(); filter.add(new Match("UserID", c.UserID)); filter.add(new Match("CompanyID", company.CompanyID)); if (EUserCompany.db.count(dbConn, filter) <= 0) { EUserCompany o = new EUserCompany(); o.UserID = c.UserID; o.CompanyID = company.CompanyID; EUserCompany.db.insert(dbConn, o); } notUserCompany.add(new Match("CompanyID", "<>", company.CompanyID)); } ArrayList unselectedUserCompanyList = EUserCompany.db.select(dbConn, notUserCompany); foreach (EUserCompany userCompany in unselectedUserCompanyList) { EUserCompany.db.delete(dbConn, userCompany); } } { DBFilter notUserRank = new DBFilter(); notUserRank.add(new Match("UserID", c.UserID)); foreach (ERank rank in newRankList) { DBFilter filter = new DBFilter(); filter.add(new Match("UserID", c.UserID)); filter.add(new Match("RankID", rank.RankID)); if (EUserRank.db.count(dbConn, filter) <= 0) { EUserRank o = new EUserRank(); o.UserID = c.UserID; o.RankID = rank.RankID; EUserRank.db.insert(dbConn, o); } notUserRank.add(new Match("RankID", "<>", rank.RankID)); } ArrayList unselectedUserRankList = EUserRank.db.select(dbConn, notUserRank); foreach (EUserRank userRank in unselectedUserRankList) { EUserRank.db.delete(dbConn, userRank); } } // Start 0000069, KuangWei, 2014-08-26 { DBFilter notPayrollGroupUser = new DBFilter(); notPayrollGroupUser.add(new Match("UserID", c.UserID)); foreach (EPayrollGroup payrollGroup in newPayGroupList) { DBFilter filter = new DBFilter(); filter.add(new Match("UserID", c.UserID)); filter.add(new Match("PayGroupID", payrollGroup.PayGroupID)); if (EPayrollGroupUsers.db.count(dbConn, filter) <= 0) { EPayrollGroupUsers o = new EPayrollGroupUsers(); o.UserID = c.UserID; o.PayGroupID = payrollGroup.PayGroupID; EPayrollGroupUsers.db.insert(dbConn, o); } notPayrollGroupUser.add(new Match("PayGroupID", "<>", payrollGroup.PayGroupID)); } ArrayList unselectedPayGroupUserList = EPayrollGroupUsers.db.select(dbConn, notPayrollGroupUser); foreach (EPayrollGroupUsers payrollGroupUsers in unselectedPayGroupUserList) { EPayrollGroupUsers.db.delete(dbConn, payrollGroupUsers); } } // update paygroup isPublic flag foreach (EPayrollGroup payrollGroup in EPayrollGroup.db.select(dbConn, new DBFilter())) { DBFilter m_countFilter = new DBFilter(); m_countFilter.add(new Match("PayGroupID", payrollGroup.PayGroupID)); payrollGroup.PayGroupIsPublic = (EPayrollGroupUsers.db.count(dbConn, m_countFilter) <= 0); EPayrollGroup.db.update(dbConn, payrollGroup); } // End 0000069, KuangWei, 2014-08-26 WebUtils.EndFunction(dbConn); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/User_View.aspx?UserID=" + CurID); }
public void DeleteByUser() { bool result = false; List <ECompany> listECompanies = new List <ECompany>(); BUserCompany bUserCompany = new BUserCompany(); EUserCompany eUserCompany = new EUserCompany(); EUserCompany insertedOneUserCompany = new EUserCompany(); EUserCompany insertedTwoUserCompany = new EUserCompany(); BCorporation bCorporation = new BCorporation(); ECorporation eCorporation = new ECorporation(); BCompany bCompany = new BCompany(); ECompany eCompany = new ECompany(); BUser bUser = new BUser(); EUser eUser = new EUser(); TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew); eCorporation.CodeCorporation = Aleatory.GetString(2); eCorporation.Name = Aleatory.GetString(15); eCorporation.State = Aleatory.GetShort(); eCorporation.Audit.UserRegister = Aleatory.GetString(8); bCorporation.Insert(eCorporation); eCompany.CodeCompany = Aleatory.GetString(2); eCompany.CodeCorporation = eCorporation.CodeCorporation; eCompany.Ruc = Aleatory.GetString(11); eCompany.LongName = Aleatory.GetString(15); eCompany.State = Aleatory.GetShort(); eCompany.Audit.UserRegister = Aleatory.GetString(8); bCompany.Insert(eCompany); eUser.CodeUser = Aleatory.GetString(8); eUser.Name = Aleatory.GetString(8); eUser.Password = Aleatory.GetString(8); eUser.State = Aleatory.GetShort(); eUser.Audit.UserRegister = Aleatory.GetString(8); bUser.Insert(eUser); eUserCompany.CodeUser = eUser.CodeUser; eUserCompany.CodeCompany = eCompany.CodeCompany; bUserCompany.Insert(eUserCompany); insertedOneUserCompany = bUserCompany.Select(eUserCompany); eCompany.CodeCompany = Aleatory.GetString(2); eCompany.CodeCorporation = eCorporation.CodeCorporation; eCompany.LongName = Aleatory.GetString(15); eCompany.State = Aleatory.GetShort(); eCompany.Audit.UserRegister = Aleatory.GetString(8); bCompany.Insert(eCompany); eUserCompany.CodeUser = eUser.CodeUser; eUserCompany.CodeCompany = eCompany.CodeCompany; bUserCompany.Insert(eUserCompany); insertedTwoUserCompany = bUserCompany.Select(eUserCompany); listECompanies = bUserCompany.SelectByUser(eUser); if (listECompanies.Count == 2 && listECompanies.Exists(x => x.CodeCompany == insertedOneUserCompany.CodeCompany) && listECompanies.Exists(x => x.CodeCompany == insertedTwoUserCompany.CodeCompany)) { bUserCompany.DeleteByUser(eUser); } listECompanies = bUserCompany.SelectByUser(eUser); if (listECompanies.Count == 0) { result = true; } Assert.IsTrue(result); }