public HttpResponseMessage SaveCompany(Entities.MstCompany objCompany, 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 company = from d in db.MstCompanies where d.Id == Convert.ToInt32(id) select d;
if (company.Any())
{
if (!company.FirstOrDefault().IsLocked)
{
String oldObject = at.GetObjectString(company.FirstOrDefault());
DateTime?closingDate = null;
if (!objCompany.ClosingDate.Equals(""))
{
closingDate = Convert.ToDateTime(objCompany.ClosingDate);
}
var saveCompany = company.FirstOrDefault();
saveCompany.Company = objCompany.Company;
saveCompany.Address = objCompany.Address;
saveCompany.ContactNumber = objCompany.ContactNumber;
saveCompany.TaxNumber = objCompany.TaxNumber;
saveCompany.ClosingDate = closingDate;
saveCompany.UpdatedById = currentUserId;
saveCompany.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
String newObject = at.GetObjectString(company.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Saving Error. These company details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These company 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 LockCompany(Entities.MstCompany objCompany, 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("CompanyDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanLock)
{
var company = from d in db.MstCompanies
where d.Id == Convert.ToInt32(id)
select d;
if (company.Any())
{
if (!company.FirstOrDefault().IsLocked)
{
String oldObject = at.GetObjectString(company.FirstOrDefault());
DateTime?closingDate = null;
if (!objCompany.ClosingDate.Equals(""))
{
closingDate = Convert.ToDateTime(objCompany.ClosingDate);
Debug.WriteLine(closingDate);
}
var lockCompany = company.FirstOrDefault();
lockCompany.Company = objCompany.Company;
lockCompany.Address = objCompany.Address;
lockCompany.ContactNumber = objCompany.ContactNumber;
lockCompany.TaxNumber = objCompany.TaxNumber;
lockCompany.ClosingDate = closingDate;
lockCompany.POFooter = objCompany.POFooter;
lockCompany.RRFooter = objCompany.RRFooter;
lockCompany.CVFooter = objCompany.CVFooter;
lockCompany.SIFooter = objCompany.SIFooter;
lockCompany.ORFooter = objCompany.ORFooter;
lockCompany.JVFooter = objCompany.JVFooter;
lockCompany.SOAFooter = objCompany.SOAFooter;
lockCompany.IsRRCanReceiveOverPOQuantity = objCompany.IsRRCanReceiveOverPOQuantity;
lockCompany.PTU = objCompany.PTU;
lockCompany.PTUDateOfIssue = objCompany.PTUDateOfIssue;
lockCompany.RemoveHeaderBranch = objCompany.RemoveHeaderBranch;
lockCompany.RemoveHeaderVersion = objCompany.RemoveHeaderVersion;
lockCompany.IsLocked = true;
lockCompany.UpdatedById = currentUserId;
lockCompany.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
String newObject = at.GetObjectString(company.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These company details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These company details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock 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 LockCompany(Entities.MstCompany objCompany, 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("CompanyDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanLock)
{
var company = from d in db.MstCompanies
where d.Id == Convert.ToInt32(id)
select d;
if (company.Any())
{
if (!company.FirstOrDefault().IsLocked)
{
var lockCompany = company.FirstOrDefault();
lockCompany.Company = objCompany.Company;
lockCompany.Address = objCompany.Address;
lockCompany.ContactNumber = objCompany.ContactNumber;
lockCompany.TaxNumber = objCompany.TaxNumber;
lockCompany.IsLocked = true;
lockCompany.UpdatedById = currentUserId;
lockCompany.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These company details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These company details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock 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."));
}
}
