public HttpResponseMessage UpdateUser(String id, Entities.MstUser objUser)
{
try
{
var users = from d in db.MstUsers
where d.Id == Convert.ToInt32(id)
select d;
if (users.Any())
{
var updateUser = users.FirstOrDefault();
updateUser.FullName = objUser.FullName;
updateUser.Address = objUser.Address;
updateUser.ContactNumber = objUser.ContactNumber;
updateUser.UserTypeId = objUser.UserTypeId;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public HttpResponseMessage putUser(String id, Entities.MstUser user)
{
try
{
var users = from d in db.MstUsers where d.Id == Convert.ToInt32(id) select d;
if (users.Any())
{
var updateUser = users.FirstOrDefault();
updateUser.UserName = user.UserName;
updateUser.Password = user.Password;
updateUser.FullName = user.FullName;
updateUser.UserCardNumber = user.UserName;
updateUser.EntryUserId = UserId();
updateUser.EntryDateTime = DateTime.Today;
updateUser.UpdateUserId = UserId();
updateUser.UpdateDateTime = DateTime.Today;
updateUser.IsLocked = true;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception e)
{
// Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public Int32 postUser(Entities.MstUser user)
{
try
{
var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;
var id = User.Identity.GetUserId();
Data.MstUser newUser = new Data.MstUser();
newUser.UserName = "******";
newUser.Password = "******";
newUser.FullName = "n/a";
newUser.UserCardNumber = "n/a";
newUser.EntryUserId = userId;
newUser.EntryDateTime = DateTime.Today;
newUser.UpdateUserId = userId;
newUser.UpdateDateTime = DateTime.Today;
newUser.IsLocked = false;
newUser.AspNetUserId = id;
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
return(newUser.Id);
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
public HttpResponseMessage UpdateUser(Entities.MstUser objUpdateUser, String id)
{
try
{
var UserTypeId = from d in db.MstUsers
where d.AspNetUserId == User.Identity.GetUserId()
select d.UserTypeId;
var userId = User.Identity.GetUserId();
var currentUserType = UserTypeId.FirstOrDefault();
if (currentUserType == 1)
{
var isUserDetailExist = from d in db.MstUsers
where d.Id == Convert.ToInt32(id)
select d;
if (isUserDetailExist.Any())
{
var currentUserDetail = from d in db.MstUsers
where d.Id == Convert.ToInt32(id)
select d;
var updateUser = currentUserDetail.FirstOrDefault();
updateUser.FirstName = objUpdateUser.FirstName;
updateUser.LastName = objUpdateUser.LastName;
updateUser.UserTypeId = objUpdateUser.UserTypeId;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Unauthorized"));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public HttpResponseMessage AddUser(Entities.MstUser objMstUser)
{
try
{
Data.MstUser mstUser = new Data.MstUser
{
FirstName = objMstUser.FirstName,
LastName = objMstUser.LastName,
Password = objMstUser.Password,
UserTypeId = objMstUser.UserTypeId,
};
db.MstUsers.InsertOnSubmit(mstUser);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public HttpResponseMessage UpdateCurrentUser(Entities.MstUser objUser)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currenteAspNetUserId = User.Identity.GetUserId();
var currentUserId = currentUser.FirstOrDefault().Id;
var user = from d in db.MstUsers
where d.Id == currentUserId
select d;
if (user.Any())
{
var branch = from d in db.MstBranches
where d.Id == objUser.BranchId
select d;
if (branch.Any())
{
var account = from d in db.MstAccounts
select d;
if (account.Any())
{
var discounts = from d in db.MstDiscounts
where d.Id == objUser.DefaultSalesInvoiceDiscountId
select d;
if (discounts.Any())
{
var currentASPNetUser = from d in db.AspNetUsers
where d.Id == currenteAspNetUserId
select d;
if (currentASPNetUser.Any())
{
var updateCurrentASPNetUser = currentASPNetUser.FirstOrDefault();
updateCurrentASPNetUser.FullName = objUser.FullName;
db.SubmitChanges();
var updateCurrentUser = user.FirstOrDefault();
updateCurrentUser.FullName = objUser.FullName;
updateCurrentUser.CompanyId = objUser.CompanyId;
updateCurrentUser.BranchId = objUser.BranchId;
updateCurrentUser.IncomeAccountId = objUser.IncomeAccountId;
updateCurrentUser.SupplierAdvancesAccountId = objUser.SupplierAdvancesAccountId;
updateCurrentUser.CustomerAdvancesAccountId = objUser.CustomerAdvancesAccountId;
updateCurrentUser.InventoryType = objUser.InventoryType;
updateCurrentUser.DefaultSalesInvoiceDiscountId = objUser.DefaultSalesInvoiceDiscountId;
updateCurrentUser.SalesInvoiceName = objUser.SalesInvoiceName;
updateCurrentUser.SalesInvoiceCheckedById = objUser.SalesInvoiceCheckedById;
updateCurrentUser.SalesInvoiceApprovedById = objUser.SalesInvoiceApprovedById;
updateCurrentUser.OfficialReceiptName = objUser.OfficialReceiptName;
updateCurrentUser.IsIncludeCostStockReports = objUser.IsIncludeCostStockReports;
updateCurrentUser.UpdatedById = currentUserId;
updateCurrentUser.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Current user not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Sales Invoice Discount not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Some Account data not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Branch not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These user details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public HttpResponseMessage LockUser(Entities.MstUser objUser, String id)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("UserDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanLock)
{
var user = from d in db.MstUsers
where d.Id == Convert.ToInt32(id)
select d;
if (user.Any())
{
if (!user.FirstOrDefault().IsLocked)
{
var branch = from d in db.MstBranches
where d.Id == objUser.BranchId
select d;
if (branch.Any())
{
var account = from d in db.MstAccounts
select d;
if (account.Any())
{
var discounts = from d in db.MstDiscounts
where d.Id == objUser.DefaultSalesInvoiceDiscountId
select d;
if (discounts.Any())
{
var lockUser = user.FirstOrDefault();
lockUser.FullName = objUser.FullName;
lockUser.CompanyId = objUser.CompanyId;
lockUser.BranchId = objUser.BranchId;
lockUser.IncomeAccountId = objUser.IncomeAccountId;
lockUser.SupplierAdvancesAccountId = objUser.SupplierAdvancesAccountId;
lockUser.CustomerAdvancesAccountId = objUser.CustomerAdvancesAccountId;
lockUser.InventoryType = objUser.InventoryType;
lockUser.DefaultSalesInvoiceDiscountId = objUser.DefaultSalesInvoiceDiscountId;
lockUser.SalesInvoiceName = objUser.SalesInvoiceName;
lockUser.SalesInvoiceCheckedById = objUser.SalesInvoiceCheckedById;
lockUser.SalesInvoiceApprovedById = objUser.SalesInvoiceApprovedById;
lockUser.OfficialReceiptName = objUser.OfficialReceiptName;
lockUser.IsIncludeCostStockReports = objUser.IsIncludeCostStockReports;
lockUser.IsLocked = true;
lockUser.UpdatedById = currentUserId;
lockUser.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Sales Invoice Discount not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Some Account data not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Branch not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These user details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These user details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock user."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this user page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public HttpResponseMessage SaveUser(Entities.MstUser objUser, String id)
{
try
{
var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var user = from d in db.MstUsers where d.Id == Convert.ToInt32(id) select d;
if (user.Any())
{
if (!user.FirstOrDefault().IsLocked)
{
var branch = from d in db.MstBranches where d.Id == objUser.BranchId select d;
if (branch.Any())
{
var account = from d in db.MstAccounts select d;
if (account.Any())
{
var discounts = from d in db.MstDiscounts where d.Id == objUser.DefaultSalesInvoiceDiscountId select d;
if (discounts.Any())
{
String oldObject = at.GetObjectString(user.FirstOrDefault());
var saveUser = user.FirstOrDefault();
saveUser.FullName = objUser.FullName;
saveUser.CompanyId = objUser.CompanyId;
saveUser.BranchId = objUser.BranchId;
saveUser.IncomeAccountId = objUser.IncomeAccountId;
saveUser.SupplierAdvancesAccountId = objUser.SupplierAdvancesAccountId;
saveUser.CustomerAdvancesAccountId = objUser.CustomerAdvancesAccountId;
saveUser.InventoryType = objUser.InventoryType;
saveUser.DefaultSalesInvoiceDiscountId = objUser.DefaultSalesInvoiceDiscountId;
saveUser.SalesInvoiceName = objUser.SalesInvoiceName;
saveUser.SalesInvoiceCheckedById = objUser.SalesInvoiceCheckedById;
saveUser.SalesInvoiceApprovedById = objUser.SalesInvoiceApprovedById;
saveUser.OfficialReceiptName = objUser.OfficialReceiptName;
saveUser.IsIncludeCostStockReports = objUser.IsIncludeCostStockReports;
saveUser.ActivateAuditTrail = objUser.ActivateAuditTrail;
saveUser.UpdatedById = currentUserId;
saveUser.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
String newObject = at.GetObjectString(user.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Sales Invoice Discount not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Some Account data not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Branch not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Saving Error. These user details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These user details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
