public Int32 insertCompany(Models.MstCompany company)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstCompany newCompany = new Data.MstCompany();
newCompany.Company = "NA";
newCompany.Address = "NA";
newCompany.ContactNumber = "NA";
newCompany.TaxNumber = "NA";
newCompany.IsLocked = false;
newCompany.CreatedById = userId;
newCompany.CreatedDateTime = DateTime.Now;
newCompany.UpdatedById = userId;
newCompany.UpdatedDateTime = DateTime.Now;
db.MstCompanies.InsertOnSubmit(newCompany);
db.SubmitChanges();
return(newCompany.Id);
}
catch
{
return(0);
}
}
public Int32 insertCompany(Models.MstCompany company)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstCompany newCompany = new Data.MstCompany();
newCompany.Company = "NA";
newCompany.Address = "NA";
newCompany.ContactNumber = "NA";
newCompany.TaxNumber = "NA";
newCompany.IsLocked = false;
newCompany.CreatedById = userId;
newCompany.CreatedDateTime = DateTime.Now;
newCompany.UpdatedById = userId;
newCompany.UpdatedDateTime = DateTime.Now;
db.MstCompanies.InsertOnSubmit(newCompany);
db.SubmitChanges();
return newCompany.Id;
}
catch
{
return 0;
}
}
public HttpResponseMessage AddCompany()
{
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 currentBranchId = currentUser.FirstOrDefault().BranchId;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("CompanyList")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
Data.MstCompany newCompany = new Data.MstCompany
{
Company = "NA",
Address = "NA",
ContactNumber = "NA",
TaxNumber = "NA",
ClosingDate = null,
POFooter = "NA",
RRFooter = "NA",
CVFooter = "NA",
SIFooter = "NA",
ORFooter = "NA",
JVFooter = "NA",
SOAFooter = "NA",
IsRRCanReceiveOverPOQuantity = false,
PTU = "NA",
PTUDateOfIssue = "NA",
RemoveHeaderBranch = false,
RemoveHeaderVersion = false,
IsLocked = false,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.MstCompanies.InsertOnSubmit(newCompany);
db.SubmitChanges();
String newObject = at.GetObjectString(newCompany);
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);
return(Request.CreateResponse(HttpStatusCode.OK, newCompany.Id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add company."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this company 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 AddCompany()
{
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 currentBranchId = currentUser.FirstOrDefault().BranchId;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("CompanyList")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
Data.MstCompany newCompany = new Data.MstCompany
{
Company = "NA",
Address = "NA",
ContactNumber = "NA",
TaxNumber = "NA",
IsLocked = false,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.MstCompanies.InsertOnSubmit(newCompany);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK, newCompany.Id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add company."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this company 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."));
}
}
