public Int32 insertAccountCashFlow(Models.MstAccountCashFlow accountCashFlow)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstAccountCashFlow newAccountCashFlow = new Data.MstAccountCashFlow();
newAccountCashFlow.AccountCashFlowCode = accountCashFlow.AccountCashFlowCode;
newAccountCashFlow.AccountCashFlow = accountCashFlow.AccountCashFlow;
newAccountCashFlow.IsLocked = accountCashFlow.IsLocked;
newAccountCashFlow.CreatedById = userId;
newAccountCashFlow.CreatedDateTime = DateTime.Now;
newAccountCashFlow.UpdatedById = userId;
newAccountCashFlow.UpdatedDateTime = DateTime.Now;
db.MstAccountCashFlows.InsertOnSubmit(newAccountCashFlow);
db.SubmitChanges();
return newAccountCashFlow.Id;
}
catch
{
return 0;
}
}
public Int32 insertAccountCashFlow(Models.MstAccountCashFlow accountCashFlow)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstAccountCashFlow newAccountCashFlow = new Data.MstAccountCashFlow();
newAccountCashFlow.AccountCashFlowCode = accountCashFlow.AccountCashFlowCode;
newAccountCashFlow.AccountCashFlow = accountCashFlow.AccountCashFlow;
newAccountCashFlow.IsLocked = accountCashFlow.IsLocked;
newAccountCashFlow.CreatedById = userId;
newAccountCashFlow.CreatedDateTime = DateTime.Now;
newAccountCashFlow.UpdatedById = userId;
newAccountCashFlow.UpdatedDateTime = DateTime.Now;
db.MstAccountCashFlows.InsertOnSubmit(newAccountCashFlow);
db.SubmitChanges();
return(newAccountCashFlow.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage AddAccountCashFlow(Entities.MstAccountCashFlow objAccountCashFlow)
{
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)
{
Data.MstAccountCashFlow newAccountCashFlow = new Data.MstAccountCashFlow
{
AccountCashFlowCode = objAccountCashFlow.AccountCashFlowCode,
AccountCashFlow = objAccountCashFlow.AccountCashFlow,
IsLocked = true,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.MstAccountCashFlows.InsertOnSubmit(newAccountCashFlow);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "No rights."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "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."));
}
}
