// GET api/FormUserPermission
public HttpResponseMessage GetFormUserPermissions()
{
LoginUser loginUser = new LoginUser();
long id = (long)loginUser.UserID;
var useperm = db.FormUserPermissions.Where(u => u.UserID == id);
var result = from x in db.FormLists
join y in useperm on x.FormID equals y.FormID into userPermission
from xy in userPermission.DefaultIfEmpty()
select new
{
FormUserPermissionID = xy.FormUserPermissionID == null ? 0 : xy.FormUserPermissionID,
UserID = id,
FormUserPermissionCode = xy.FormUserPermissionCode,
state=x.state,
FormID = x.FormID,
View = xy.View == null ? false : xy.View,
Insert = xy.Insert == null ? false : xy.Insert,
Update = xy.Update == null ? false : xy.Update,
Delete = xy.Delete == null ? false : xy.Delete,
FormName = x.FormName,
ModuleName = x.Module.ModuleName
};
//return db.AccCOAMappings.AsEnumerable();
return Request.CreateResponse(HttpStatusCode.OK, result.ToList());
}
//public long CreateCOA(string headFor, long ParentCOAID)
//{
// long COAID = ParentCOAID;
// //var query=from x in
// return COAID;
//}
public long CreateCOA(string headFor, long coaid)
{
try
{
LoginUser loginUser = new LoginUser();
long COAID = 0;
long? CompanyID = loginUser.CompanyID;
var query = (from x in db.AccCOAMappings
from y in db.AccCOAs
.Where(p => (p.COAID == x.AccCOAID))
.DefaultIfEmpty()
select new { x.AccCOAID, x.Prefix, x.Suffix, x.CreateChild, y.COACode, y.COAName, y.HasChild, y.BalanceType, y.AccTypeID, y.CompanyID, y.CompanyBranchID, x.AccCOAConfigID }).Where(c => c.AccCOAConfigID == coaid && c.CompanyID == CompanyID).SingleOrDefault();
if (query != null)
{
if (query.CreateChild == true)
{
int? MaxCode = Convert.ToInt32((db.AccCOAs.Where(r => r.ParentCOAID == query.AccCOAID).Select(r => r.COACode).ToList()).Max());
AccCOA accCOA = new AccCOA();
accCOA.AccTypeID = query.AccTypeID;
accCOA.BalanceType = query.BalanceType;
accCOA.CompanyID = query.CompanyID;
accCOA.CompanyBranchID = query.CompanyBranchID;
accCOA.COAName = query.Prefix + headFor + query.Suffix + ":" + query.COAName;
accCOA.COACode = MaxCode > 0 ? (MaxCode + 1).ToString() : query.COACode.ToString() + "001";
accCOA.ParentCOAID = (long)query.AccCOAID;
db.AccCOAs.Add(accCOA);
db.SaveChanges();
COAID = accCOA.COAID;
}
else
{
COAID = Convert.ToInt64(query.AccCOAID);
}
}
return COAID;
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public ActionResult Index()
{
LoginUser loginUser = new LoginUser();
ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";
//object id = Membership.FindUsersByName(Membership.GetUser().UserName.ToString());
ViewBag.BgColor = "#006442";
ViewBag.User = loginUser; //Membership.GetUser().UserName.ToString().ToUpper();
return View();
//return Redirect("index.html");
}
// PUT api/PurchaseBill/5
public HttpResponseMessage PutPurchaseBill(long id, PurchaseBill purchasebill)
{
LoginUser loginUser = new LoginUser();
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
if (id != purchasebill.PurchaseBillID)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
if (purchasebill.IsApproved==true)
{
long PurchaseCOAID =Convert.ToInt64 (db.AccCOAMappings.Where(a => a.AccCOAConfigID == 22 && a.CompanyID == loginUser.CompanyID).Select(a => a.AccCOAID).SingleOrDefault());
ControlVoucher controlvoucher = new ControlVoucher();
var PurchaseOrder = db.PurchaseOrders.Where(o => o.PurchaseOrderID == purchasebill.PurchaseOrderID).SingleOrDefault();
if(PurchaseOrder!=null)
{
PurchaseCOAID =(long) PurchaseOrder.PurchaseOrderCategory.COAID;
}
long SupplierCOAID = (long)db.Collaborators.Where(c => c.CollaboratorID == purchasebill.SupplierID).Select(c => c.SupplierCOAID).FirstOrDefault();
purchasebill.VoucherNO = controlvoucher.CreateVoucher(PurchaseCOAID, SupplierCOAID, (decimal)purchasebill.GrandTotalApproved, (long)1, (DateTime)purchasebill.Date);
}
purchasebill.UpdateBy = loginUser.UserID;
db.Entry(purchasebill).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
}
return Request.CreateResponse(HttpStatusCode.OK);
}
