public ActionResult ConfirmDeleteTax(int PrimaryID)
{
Tbl_FMTax taxiii = (from a in BOSSDB.Tbl_FMTax where a.TaxID == PrimaryID select a).FirstOrDefault();
BOSSDB.Tbl_FMTax.Remove(taxiii);
BOSSDB.SaveChanges();
var result = "";
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteTax(int PrimaryID)
{
Tbl_FMTax taxTbl = (from a in BOSSDB.Tbl_FMTax where a.TaxID == PrimaryID select a).FirstOrDefault();
var confirmDelete = "";
if (taxTbl != null)
{
confirmDelete = "false";
}
var result = new { confirmDelete = confirmDelete };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveTax(TaxModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var desc = model.TaxList.Description;
var shortdesc = model.TaxList.ShortDescrption;
Tbl_FMTax checkTax = (from a in BOSSDB.Tbl_FMTax where (a.Description == desc) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkTax == null)
{
Tbl_FMTax taxii = new Tbl_FMTax();
taxii.Description = desc;
taxii.ShortDepscription = model.TaxList.ShortDescrption;
taxii.isUsed = model.TaxList.isUsed;
taxii.Percentage = model.TaxList.Percentage;
taxii.BaseTax = model.TaxList.BaseTax;
taxii.GAID = model.GAID;
BOSSDB.Tbl_FMTax.Add(taxii);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkTax != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMTax tax = (from a in BOSSDB.Tbl_FMTax where a.TaxID == model.TaxList.TaxID select a).FirstOrDefault();
List <Tbl_FMTax> descCount = (from e in BOSSDB.Tbl_FMTax where e.Description == desc select e).ToList();
List <Tbl_FMTax> shortdescCount = (from e in BOSSDB.Tbl_FMTax where e.ShortDepscription == shortdesc select e).ToList();
if (checkTax != null)
{
if (tax.Description == desc && tax.ShortDepscription == model.TaxList.ShortDescrption && tax.TaxID == model.TaxList.TaxID)
{
isExist = "justUpdate";
}
else
{
if (tax.Description != desc && descCount.Count >= 1 || tax.ShortDepscription != shortdesc && shortdescCount.Count >= 1)
{
isExist = "true";
}
else
{
isExist = "justUpdate";
}
}
}
else if (checkTax == null)
{
isExist = "justUpdate";
}
if (isExist == "justUpdate")
{
tax.Description = desc;
tax.ShortDepscription = model.TaxList.ShortDescrption;
tax.isUsed = model.TaxList.isUsed;
tax.Percentage = model.TaxList.Percentage;
tax.BaseTax = model.TaxList.BaseTax;
tax.GAID = model.GAID;
BOSSDB.Entry(tax);
BOSSDB.SaveChanges();
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
