public string UpdateUserPicture(TUserModel mdl, string iduserpicture)
{
if (CWU.OpenConnection())
{
CWU.command.Connection = CWU.connection;
CWU.command.CommandType = System.Data.CommandType.Text;
CWU.command.CommandText = "UPDATE [Tuser] set UserPicture = @UserPicture Where IDUser = '******' ";
if (mdl.UserPicturebyte == null)
{
CWU.command.Parameters.AddWithValue("@UserPicture", System.Data.SqlTypes.SqlBinary.Null);
}
else
{
CWU.command.Parameters.AddWithValue("@UserPicture", mdl.UserPicturebyte);
}
try
{
ret = CWU.command.ExecuteNonQuery();
}
catch (SqlException e)
{
e.Message.ToString();
}
finally
{
}
}
CWU.command.Connection.Close();
return(ret.ToString());
}
public string UpdateLockedUser(TUserModel mdl)
{
SqlDateTime sqldatetime = new SqlDateTime();
var res = "";
if (CWU.OpenConnection())
{
sql = "[UpdateStatusLocked]";
CWU.command.CommandText = sql;
CWU.command.Connection = CWU.connection;
CWU.command.CommandType = System.Data.CommandType.StoredProcedure;
CWU.command.Parameters.AddWithValue("@iduser", mdl.UserID);
CWU.command.Parameters.AddWithValue("@type", mdl.Locked);
CWU.command.Parameters.AddWithValue("@userupdateby", mdl.UserLastMaintenance);
try
{
int ret = CWU.command.ExecuteNonQuery();
res = "1";
}
catch (SqlException e)
{
res = e.Message.ToString();
}
finally
{
CWU.command.Connection.Close();
}
}
return(res);
}
public string SelectProfilePicture(string iduserpicture)
{
string res = "";
if (CWU.OpenConnection())
{
String sql = "SELECT UserPicture FROM dbo.[Tuser] AS a WHERE IDUser='******'";
CWU.command.CommandType = System.Data.CommandType.Text;
CWU.command.CommandText = sql;
CWU.command.Connection = CWU.connection;
//SqlDataReader rdr = cmd.ExecuteReader();
CWU.dtreader = CWU.command.ExecuteReader();
//Site.totalrecods = CWU.dtreader();
while (CWU.dtreader.Read())
{
var Profic = new TUserModel();
//Profic.IDUser = CWU.dtreader[0].ToString();
res = CWU.dtreader[0].ToString() != "" ? Convert.ToBase64String((byte[])CWU.dtreader[0]) : "";
}
}
CWU.dtreader.Close();
CWU.command.Connection.Close();
return(res);
}
public String UserDelete(TUserModel mdl)
{
try
{
string ret = "";
var res = db.PTUserDelete(mdl.IDUser, mdl.UserLastMaintenance, Convert.ToDateTime(mdl.DateLastMaintenance)).FirstOrDefault();
if (res.Error == 0 || res.Error == null)
{
var retSplit = res.Pesan.Split('|');
ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelUserName, retSplit[1]);
ret = "1";
}
else
{
ret = "Err|" + res.Pesan;
ret = "0";
}
return(ret);
}
catch (SqlException e)
{
return("Err|" + e.InnerException.Message);
//return "0|" + e.Message;
}
}
public ActionResult Update(TUserModel mdl)
{
var base64 = mdl.UserPicture.Substring(mdl.UserPicture.IndexOf(',') + 1);
var binary = Convert.FromBase64String(base64);
mdl.UserPicturebyte = binary;
string ret = "";
mdl.UserLastMaintenance = Session["IDUser"].ToString();
try
{
// ret = EMC.EmployeeInsert(ins, IsActive);
ret = User.UserUpdate(mdl);
}
catch (Exception err)
{
ret = err.Message;
return(Json(new { result = ret }));
}
return(Json(new { result = ret }));
}
public ActionResult Create(TUserModel mdl)
{
var base64 = mdl.UserPicture.Substring(mdl.UserPicture.IndexOf(',') + 1);
var binary = Convert.FromBase64String(base64);
mdl.UserPicturebyte = binary;
mdl.Password = "******";
string ret = "";
mdl.UserEntry = Session["IDUser"].ToString();
//if (ModelState.IsValid)
//{
try
{
// ret = EMC.EmployeeInsert(ins, IsActive);
ret = User.InsertUser(mdl);
}
catch (Exception err)
{
ret = err.Message;
return(Json(new { result = ret }));
}
// }
return(Json(new { result = ret }));
}
public ActionResult SubmitForm(TUserModel model, string avatar)
{
if (!string.IsNullOrEmpty(avatar))
{
model.Photo = Convert.FromBase64String(avatar.Split(',')[1]);
}
if (this.bll.GetModel(p => p.Code == model.Code && p.ID != model.ID) != null)
{
return(Content("用户编号重复，请核查"));
}
if (model.ID == -1)
{
this.bll.Insert(model);
}
else
{
this.bll.Update(model);
}
return(Content("操作成功！"));
}
public ActionResult UpdateUserLocked(TUserModel mdl)
{
mdl.UserLastMaintenance = Session["IDUser"].ToString();
var ret = "";
try
{
// ret = EMC.EmployeeInsert(ins, IsActive);
ret = User.UpdateLockedUser(mdl);
}
catch (Exception err)
{
ret = err.Message;
return(Json(new { result = ret }));
}
return(Json(new { result = ret }));
}
public ActionResult UpdatePassword(TUserModel mdl)
{
string ret = "";
//mdl.Locked = false;
mdl.IDUser = Session["IDUser"].ToString();
mdl.UserLastMaintenance = Session["IDUser"].ToString();
// mdl.DateLastMaintenance = DateTime.Now;
if (ModelState.IsValid)
{
try
{
ret = User.UserUpdatePassword(mdl);
}
catch (Exception err)
{
ret = "Err|" + err.Message;
}
}
return(Json(new { result = ret }));
}
public List <TUserModel> SelectOperationAdditionalPermisions(string ID)
{
if (CWU.OpenConnection())
{
var sql = "select count(*) from dbo.UserAdditionalPermissions AS a where a.UserID ='" + ID + "'";
CWU.command.CommandType = System.Data.CommandType.Text;
CWU.command.CommandText = sql;
CWU.command.Connection = CWU.connection;
CWU.dtreader = CWU.command.ExecuteReader();
while (CWU.dtreader.Read())
{
var SubStore = new TUserModel();
SubStore.IsCreate = CWU.dtreader[0].ToString();
//SubStore.SubStoreName = CWU.dtreader[1].ToString();
modelUser.Add(SubStore);
}
}
CWU.dtreader.Close();
CWU.command.Connection.Close();
return(modelUser);
}
public string InsertUser(TUserModel mdl)
{
SqlDateTime sqldatetime = new SqlDateTime();
var res = "";
if (CWU.OpenConnection())
{
sql = "[PTUserInsert]";
CWU.command.CommandText = sql;
CWU.command.Connection = CWU.connection;
CWU.command.CommandType = System.Data.CommandType.StoredProcedure;
CWU.command.Parameters.AddWithValue("@UserCode", mdl.UserCode);
CWU.command.Parameters.AddWithValue("@UserName", mdl.Username);
CWU.command.Parameters.AddWithValue("@Password", mdl.Password);
CWU.command.Parameters.AddWithValue("@Fullname", mdl.Fullname);
CWU.command.Parameters.AddWithValue("@Email", mdl.Email);
CWU.command.Parameters.AddWithValue("@IDRole", mdl.IDRole);
CWU.command.Parameters.AddWithValue("@UserEntry", mdl.UserEntry);
CWU.command.Parameters.AddWithValue("@DateEntry", DateTime.Now);
CWU.command.Parameters.AddWithValue("@Locked", false);
CWU.command.Parameters.AddWithValue("@site", mdl.IDSite);
CWU.command.Parameters.AddWithValue("@userPicture", mdl.UserPicturebyte);
CWU.command.Parameters.AddWithValue("@employeeNo", mdl.EmployeeNO);
try
{
int ret = CWU.command.ExecuteNonQuery();
res = "1";
}
catch (SqlException e)
{
res = e.Message.ToString();
}
finally
{
CWU.command.Connection.Close();
}
}
return(res);
}
public string UserUpdate(TUserModel mdl)
{
SqlDateTime sqldatetime = new SqlDateTime();
var res = "";
if (CWU.OpenConnection())
{
sql = "[PTUserUpdate]";
CWU.command.CommandText = sql;
CWU.command.Connection = CWU.connection;
CWU.command.CommandType = System.Data.CommandType.StoredProcedure;
CWU.command.Parameters.AddWithValue("@IDUser", mdl.UserID);
CWU.command.Parameters.AddWithValue("@UserCode", mdl.UserCode);
CWU.command.Parameters.AddWithValue("@UserName", mdl.Username);
CWU.command.Parameters.AddWithValue("@employeeno", mdl.EmployeeNO);
CWU.command.Parameters.AddWithValue("@Fullname", mdl.Fullname);
CWU.command.Parameters.AddWithValue("@Email", mdl.Email);
CWU.command.Parameters.AddWithValue("@userpicture", mdl.UserPicturebyte);
CWU.command.Parameters.AddWithValue("@IDRole", mdl.IDRole);
CWU.command.Parameters.AddWithValue("@UserLastMaintanance", mdl.UserLastMaintenance);
try
{
int ret = CWU.command.ExecuteNonQuery();
res = "1";
}
catch (SqlException e)
{
res = e.Message.ToString();
}
finally
{
CWU.command.Connection.Close();
}
}
return(res);
}
public ActionResult Form(int id)
{
var model = this.bll.GetModel(id);
if (model == null)
{
model = new TUserModel()
{
ID = -1
}
}
;
if (model.Photo != null)
{
this.ViewBag.avatar = "data:image/png;base64," + Convert.ToBase64String(model.Photo);
}
var unitModel = this.unitBll.GetModel(p => p.unitSeq == model.unitSeq);
this.ViewBag.unitName = unitModel == null ? "" : unitModel.unitName;
this.ViewBag.unitList = JsonConvert.SerializeObject(unitBll.GetModelList());
this.ViewBag.Sex = dicBll.GetModelListByName(FDictionaryString.UserSex);
this.ViewBag.State = dicBll.GetModelListByName(FDictionaryString.WorkState);
return(View(model));
}
public string UserUpdatePassword(TUserModel mdl)
{
var ret = "";
if (CWU.OpenConnection())
{
CWU.command.Connection = CWU.connection;
CWU.command.CommandType = System.Data.CommandType.StoredProcedure;
CWU.command.CommandText = "PTUserUpdatePassword";
CWU.command.Parameters.AddWithValue("@IDUser", mdl.IDUser);
CWU.command.Parameters.AddWithValue("@Password", mdl.Password);
CWU.command.Parameters.AddWithValue("@UserLastMaintanance", mdl.IDUser);
//CWU.command.Parameters.AddWithValue("@oldPassword", mdl.OldPassword);
CWU.dtreader = CWU.command.ExecuteReader();
while (CWU.dtreader.Read())
{
ret = CWU.dtreader[0].ToString();
}
//CWU.command.CommandText = "INSERT INTO PMMeterReading ( PMMeterID , CurrentReading , ReadingDate , IsActive , UserEntry , DateEntry , GenerateStatus) Values ( '"+mdl.PMMeterID+"' , '"+mdl.CurrentReading+"' , '"+mdl.ReadingDate+"' , 1 , '"+mdl.UserEntry+"' , '"+mdl.DateEntry+"' , 0)";
}
CWU.dtreader.Close();
CWU.command.Connection.Close();
return(ret.ToString());
}
public int Delete(TUserModel model)
{
return(this.dal.Delete(model));
}
public TUserModel Insert(TUserModel model)
{
return(db.Insert(model));
}
public TUserModel Insert(TUserModel model)
{
return(this.dal.Insert(model));
}
public int Update(TUserModel model)
{
return(this.dal.Update(model));
}
public List <TUserModel> SelectAdditionalPermisions(string ID)
{
if (CWU.OpenConnection())
{
modelUser.Clear();
var sql = "select a.UserAdditionalPermissionsID, " +
" a.UserID, " +
" a.AllowReOpenWO, " +
" a.AllowAssignWO, " +
" a.AllowCloseWO," +
" a.AllowCancelWO," +
" a.AllotToViewCostWO," +
" a.AllowMaterialReturnFromWO," +
" a.AllowMaterialIssueFromWO," +
" a.CanViewAssignWOOnly," +
" a.AllowPMGeneration," +
" a.AllowToCreatePR," +
" a.AllowToReopenPR," +
" a.AllowToCancelPR," +
" a.AllowToApprovedPR," +
" a.AllowToCreatePO," +
" a.AllowToReopenPO," +
" a.AloowToAuthorizedPO," +
" a.AllowToCancelPO," +
" a.AllowToPrintPO," +
" a.RegisterInvoiceTo," +
" a.POApprovalAmount," +
" a.AllowToCreateGRN," +
" a.AllowAdjusment," +
" a.LimitWebRequest," +
" a.AllowCancelWR," +
" a.AllowChangeStatus , a.AllowToChecklistGR , a.AllowToClosePO , a.AllowToCloseSO , a.AllowToAcceptGRTolleranceLimit" +
" from dbo.UserAdditionalPermissions AS a where a.UserID ='" + ID + "'";
CWU.command.CommandType = System.Data.CommandType.Text;
CWU.command.CommandText = sql;
CWU.command.Connection = CWU.connection;
CWU.dtreader = CWU.command.ExecuteReader();
while (CWU.dtreader.Read())
{
var UM = new TUserModel();
UM.UserAdditionalPermissionsID = CWU.dtreader[0].ToString();
UM.UserID = CWU.dtreader[1].ToString();
UM.AllowReOpenWO = CWU.dtreader[2].ToString();
UM.AllowAssignWO = CWU.dtreader[3].ToString();
UM.AllowCloseWO = CWU.dtreader[4].ToString();
UM.AllowCancelWO = CWU.dtreader[5].ToString();
UM.AllotToViewCostWO = CWU.dtreader[5].ToString();
UM.AllowMaterialReturnFromWO = CWU.dtreader[7].ToString();
UM.AllowMaterialIssueFromWO = CWU.dtreader[8].ToString();
UM.CanViewAssignWOOnly = CWU.dtreader[9].ToString();
UM.AllowPMGeneration = CWU.dtreader[10].ToString();
UM.AllowToCreatePR = CWU.dtreader[11].ToString();
UM.AllowToReopenPR = CWU.dtreader[12].ToString();
UM.AllowToCancelPR = CWU.dtreader[13].ToString();
UM.AllowToApprovedPR = CWU.dtreader[14].ToString();
UM.AllowToCreatePO = CWU.dtreader[15].ToString();
UM.AllowToReopenPO = CWU.dtreader[16].ToString();
UM.AloowToAuthorizedPO = CWU.dtreader[17].ToString();
UM.AllowToCancelPO = CWU.dtreader[18].ToString();
UM.AllowToPrintPO = CWU.dtreader[19].ToString();
UM.RegisterInvoiceTo = CWU.dtreader[20].ToString();
UM.POApprovalAmount = CWU.dtreader[21].ToString();
UM.AllowToCreateGRN = CWU.dtreader[22].ToString();
UM.AllowAdjusment = CWU.dtreader[23].ToString();
UM.LimitWebRequest = CWU.dtreader[24].ToString();
UM.AllowCancelWR = CWU.dtreader[25].ToString();
UM.AllowChangeStatus = CWU.dtreader[26].ToString();
UM.AllowToChecklistGR = CWU.dtreader[27].ToString();
UM.AllowToClosePO = CWU.dtreader[28].ToString();
UM.AllowToCloseSO = CWU.dtreader[29].ToString();
UM.AllowToAcceptGRTolleranceLimit = CWU.dtreader[30].ToString();
modelUser.Add(UM);
}
}
CWU.dtreader.Close();
CWU.command.Connection.Close();
return(modelUser);
}
