public HttpResponseMessage AddAccountType(Entities.MstAccountType objAccountType)
{
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("ChartOfAccounts")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var accountCategories = from d in db.MstAccountCategories
where d.IsLocked == true &&
d.Id == objAccountType.AccountCategoryId
select d;
if (accountCategories.Any())
{
Data.MstAccountType newAccountType = new Data.MstAccountType
{
AccountTypeCode = objAccountType.AccountTypeCode,
AccountType = objAccountType.AccountType,
AccountCategoryId = objAccountType.AccountCategoryId,
SubCategoryDescription = objAccountType.SubCategoryDescription,
IsLocked = true,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.MstAccountTypes.InsertOnSubmit(newAccountType);
db.SubmitChanges();
String newObject = at.GetObjectString(newAccountType);
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Account category not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "No rights."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "No rights."));
}
}
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 AddAccountType(Entities.MstAccountType objAccountType)
{
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("ChartOfAccounts")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var accountCategories = from d in db.MstAccountCategories
where d.IsLocked == true
select d;
if (accountCategories.Any())
{
Data.MstAccountType newAccountType = new Data.MstAccountType
{
AccountTypeCode = objAccountType.AccountTypeCode,
AccountType = objAccountType.AccountType,
AccountCategoryId = objAccountType.AccountCategoryId,
SubCategoryDescription = objAccountType.SubCategoryDescription,
IsLocked = objAccountType.IsLocked,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.MstAccountTypes.InsertOnSubmit(newAccountType);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "No account category found. Please setup more account categories for all chart of account tables."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new account type in this chart of account page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this chart of account 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 UpdateAccountType(Entities.MstAccountType objAccountType, 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("ChartOfAccounts")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanEdit)
{
var accountCategories = from d in db.MstAccountCategories
where d.IsLocked == true &&
d.Id == objAccountType.AccountCategoryId
select d;
if (accountCategories.Any())
{
var accountType = from d in db.MstAccountTypes
where d.Id == Convert.ToUInt32(id)
select d;
if (accountType.Any())
{
String oldObject = at.GetObjectString(accountType.FirstOrDefault());
var updateAccountType = accountType.FirstOrDefault();
updateAccountType.AccountTypeCode = objAccountType.AccountTypeCode;
updateAccountType.AccountType = objAccountType.AccountType;
updateAccountType.AccountCategoryId = objAccountType.AccountCategoryId;
updateAccountType.SubCategoryDescription = objAccountType.SubCategoryDescription;
updateAccountType.IsLocked = true;
updateAccountType.UpdatedById = currentUserId;
updateAccountType.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
String newObject = at.GetObjectString(accountType.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "This account type detail is no longer available."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Account category not found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "No rights."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "No rights."));
}
}
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 UpdateAccountType(Entities.MstAccountType objAccountType, 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("ChartOfAccounts")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanEdit)
{
var accountCategories = from d in db.MstAccountCategories
where d.IsLocked == true
select d;
if (accountCategories.Any())
{
var accountType = from d in db.MstAccountTypes
where d.Id == Convert.ToUInt32(id)
select d;
if (accountType.Any())
{
var updateAccountType = accountType.FirstOrDefault();
updateAccountType.AccountTypeCode = objAccountType.AccountTypeCode;
updateAccountType.AccountType = objAccountType.AccountType;
updateAccountType.AccountCategoryId = objAccountType.AccountCategoryId;
updateAccountType.SubCategoryDescription = objAccountType.SubCategoryDescription;
updateAccountType.IsLocked = objAccountType.IsLocked;
updateAccountType.UpdatedById = currentUserId;
updateAccountType.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "This account type detail is no longer exist in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "No account category found. Please setup more account categories for all chart of account tables."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to edit and update account type in this chart of account page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this chart of account 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."));
}
}
