public void DoInsertUser(tsecuser user, List<tsecuserrole> lstUserRole)
{
try
{
dbInstance.BeginTransaction();
localDal.DoInsert<tsecuser>(user);
#region Flow
for (int i = 0; i < lstUserRole.Count; i++)
{
localDal.DoInsert<tsecuserrole>(lstUserRole[i]);
}
#endregion
dbInstance.Commit();
}
catch (Exception ex)
{
dbInstance.Rollback();
throw ex;
}
finally
{
dbInstance.CloseConnection();
}
}
public void DoInsertUser(ContextInfo contextInfo, tsecuser user, List<tsecuserrole> lstUserRole)
{
contextInfo.Action = MES_ActionType.Insert;
UserBll bll = new UserBll(contextInfo);
bll.CallAccessControl();
bll.DoInsertUser(user, lstUserRole);
GC.Collect();
}
public void DoUpdateUser(tsecuser user, List<tsecuserrole> lstUserRole)
{
try
{
dbInstance.BeginTransaction();
localDal.DoUpdate<tsecuser>(user);
#region Flow
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "userid",
ParamValue = user.userid,
ParamType = "string"
});
localDal.DoDelete<tsecuserrole>(lstParameters);
for (int i = 0; i < lstUserRole.Count; i++)
{
localDal.DoInsert<tsecuserrole>(lstUserRole[i]);
}
#endregion
dbInstance.Commit();
}
catch (Exception ex)
{
dbInstance.Rollback();
throw ex;
}
finally
{
dbInstance.CloseConnection();
}
}
/// <summary>
/// Create a new tsecuser object.
/// </summary>
/// <param name="userid">Initial value of the userid property.</param>
/// <param name="employeeid">Initial value of the employeeid property.</param>
/// <param name="createdtime">Initial value of the createdtime property.</param>
/// <param name="createduser">Initial value of the createduser property.</param>
/// <param name="lastmodifiedtime">Initial value of the lastmodifiedtime property.</param>
/// <param name="lastmodifieduser">Initial value of the lastmodifieduser property.</param>
public static tsecuser Createtsecuser(global::System.String userid, global::System.String employeeid, global::System.DateTime createdtime, global::System.String createduser, global::System.DateTime lastmodifiedtime, global::System.String lastmodifieduser)
{
tsecuser tsecuser = new tsecuser();
tsecuser.userid = userid;
tsecuser.employeeid = employeeid;
tsecuser.createdtime = createdtime;
tsecuser.createduser = createduser;
tsecuser.lastmodifiedtime = lastmodifiedtime;
tsecuser.lastmodifieduser = lastmodifieduser;
return tsecuser;
}
/// <summary>
/// Deprecated Method for adding a new object to the tsecuser EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotsecuser(tsecuser tsecuser)
{
base.AddObject("tsecuser", tsecuser);
}
