public async Task <IActionResult> UpdateUser([FromBody] VW_UserDetail vw_UserDetail)
{
var Transaction = _repo.BeginTrainsaction();
try
{
await _repo.userCreationCRUD.UpdateUser(vw_UserDetail);
await _repo.vsecLoginMst.UpdateLogin(vw_UserDetail);
Transaction.Commit();
return(NoContent());
}
catch (Exception ex)
{
Transaction.Rollback();
_logger.LogError($"Something went wrong inside UpdateUser action: {ex.Message}");
return(StatusCode(500, "Internal server error"));
}
finally
{
Transaction.Dispose();
}
}
public async Task UpdateUser(VW_UserDetail vw_userdetail)
{
VsecUserMst vsec_user_mst = new VsecUserMst
{
UserMstId = vw_userdetail.UserMstID,
FirstName = vw_userdetail.FirstName,
MiddleName = vw_userdetail.MiddleName,
LastName = vw_userdetail.LastName,
FatherName = vw_userdetail.FatherName,
Dob = vw_userdetail.DOB,
Gender = vw_userdetail.Gender,
Email = vw_userdetail.Email,
Address1 = vw_userdetail.Address1,
Address2 = vw_userdetail.Address2,
Address3 = vw_userdetail.Address3,
ContactNo = vw_userdetail.ContactNo,
Status = vw_userdetail.Status,
McStatus = vw_userdetail.Status,
CreatedBy = vw_userdetail.CreatedBy,
CreatedOn = DateTime.Now,
P1 = vw_userdetail.P1
};
Update(vsec_user_mst);
await SaveAsync();
}
public async Task <IActionResult> CreateUser([FromBody] VW_UserDetail vw_UserDetail)
{
var Transaction = _repo.BeginTrainsaction();
try
{
await _repo.userCreationCRUD.CreateUser(vw_UserDetail);
vw_UserDetail.UserMstID = _repo.userCreationCRUD.MaxUserMstID().Result;
await _repo.vsecLoginMst.CreatLogin(vw_UserDetail);
Transaction.Commit();
return(CreatedAtRoute("UserById", new { id = vw_UserDetail.UserMstID }, vw_UserDetail));
}
catch (Exception ex)
{
Transaction.Rollback();
_logger.LogError($"Something went wrong inside CreateUser action: {ex.Message}");
return(StatusCode(500, "Internal server error"));
}
finally
{
Transaction.Dispose();
}
}
public VW_UserDetail GetUserByID(int ID)
{
try
{
VW_UserDetail vw_usedetail = _db.VW_UserDetail.Where(r => r.UserMstID == ID).SingleOrDefault();
return(vw_usedetail);
}
catch (Exception e)
{
throw;
}
}
public async Task UpdateLogin(VW_UserDetail vw_userdetail)
{
VsecLoginMst vsecLoginMst = new VsecLoginMst
{
LoginMid = vw_userdetail.LoginMId,
LoginId = vw_userdetail.LoginID,
ProfileId = vw_userdetail.ProfileId,
ActiveStatus = vw_userdetail.Status,
Password = vw_userdetail.RPassword,
CreatedBy = vw_userdetail.CreatedBy,
CreatedOn = DateTime.Now
};
Update(vsecLoginMst);
await SaveAsync();
}
// GET: UserCRUD
public JsonResult UpdateUser(VW_UserDetail vw_userdetail)
{
try
{
string Message = string.Empty;
bool flag = false;
try
{
if (vw_userdetail != null)
{
string LoginID = string.Empty;
GVObjDict = new Dictionary <string, string>();
GVObjDict = (Dictionary <string, string>)Session["GMVSession"];
GVObjDict.TryGetValue("LoginID", out LoginID);
vw_userdetail.CreatedBy = LoginID;
_IVW_UserDetail.UpdateUser(vw_userdetail);
Message = "User updated Successfully";
flag = true;
}
else
{
return(Json("Failed"));
}
}
catch (Exception)
{
Message = "User update failed! Please try again";
}
return(new JsonResult {
Data = new { Message = Message, Status = flag }
});
}
catch (Exception)
{
throw;
}
}
public void CreatUser(VW_UserDetail vw_userdetail)
{
try
{
if (vw_userdetail != null)
{
VSEC_USER_MST vsec_user_mst = new VSEC_USER_MST
{
UserMstID = _db.VSEC_USER_MST.Max(m => m.UserMstID) + 1,
FirstName = vw_userdetail.FirstName,
MiddleName = vw_userdetail.MiddleName,
LastName = vw_userdetail.LastName,
FatherName = vw_userdetail.FatherName,
DOB = vw_userdetail.DOB,
Gender = vw_userdetail.Gender,
Email = vw_userdetail.Email,
Address1 = vw_userdetail.Address1,
Address2 = vw_userdetail.Address2,
Address3 = vw_userdetail.Address3,
ContactNo = vw_userdetail.ContactNo,
Status = vw_userdetail.Status == "true" ? "A" : "D",
MC_Status = vw_userdetail.Status == "true" ? "A" : "D",
CreatedBy = vw_userdetail.CreatedBy,
CreatedOn = DateTime.Now,
P1 = vw_userdetail.P1
};
VSEC_LOGIN_MST vsec_login_mst = new VSEC_LOGIN_MST
{
LoginMId = 0,
LoginID = vw_userdetail.LoginID,
ProfileId = vw_userdetail.ProfileId,
ActiveStatus = vw_userdetail.Status == "true" ? "Y" : "N",
Password = vw_userdetail.RPassword,
CreatedBy = vw_userdetail.CreatedBy,
CreatedOn = DateTime.Now
};
_db.VSEC_USER_MST.Add(vsec_user_mst);
using (System.Data.Entity.DbContextTransaction dbTran = _db.Database.BeginTransaction())
{
try
{
_db.SaveChanges();
vsec_login_mst.UserMstID = _db.VSEC_USER_MST.Max(m => m.UserMstID);
_db.VSEC_LOGIN_MST.Add(vsec_login_mst);
_db.SaveChanges();
dbTran.Commit();
}
catch (System.Data.Entity.Validation.DbEntityValidationException e)
{
dbTran.Rollback();
}
}
}
}
catch (Exception e)
{
throw;
}
}
