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);
}
