public ActionResult CreateProjectAjax(Project modelProject)
{
ModelState.Remove("UserID");
if (!Request.IsAjaxRequest())
{
TempData["ResultError"] = "Грешка в добавяне на адрес!";
return(Json(false));
}
if (!ModelState.IsValid)
{
TempData["ResultError"] = "Грешка в добавяне на адрес!";
return(Json(false));
}
using (var context = new AkcetModel())
{
modelProject.DateCreated = DateTime.Now;
modelProject.DateModified = DateTime.Now;
modelProject.UserID = User.Identity.GetUserId();
modelProject.UserName = User.Identity.Name;
modelProject.IsDeleted = false;
db.Projects.Add(modelProject);
db.SaveChanges();
return(Json(new { id = modelProject.ProjectID, value = modelProject.ProjectName }));
}
}
public JsonResult CreateInvoiceAjax(string Companies, FakturiTemp Fakturi)
{
if (Companies == "0")
{
return(Json(false));
}
if (String.IsNullOrWhiteSpace(Fakturi.InvoiceDate))
{
return(Json(false));
}
if (String.IsNullOrWhiteSpace(Fakturi.InvoiceEndDate))
{
return(Json(false));
}
Fakturi.CompanyID = Int32.Parse(Companies);
var userId = User.Identity.GetUserId();
using (var context = new AkcetModel())
{
var temp = new List <ProductInvoiceTemp>();
Fakturi.ProductInvoiceTemps = temp;
Fakturi.UserId = userId;
Fakturi.DateCreated = DateTime.Now;
Fakturi.DateModified = DateTime.Now;
Fakturi.UserName = User.Identity.Name;
context.FakturiTemps.Add(Fakturi);
context.SaveChanges();
}
return(Json(Fakturi));
}
public JsonResult CreateAddressAjax(Address modelAddress)
{
if (!Request.IsAjaxRequest())
{
TempData["ResultError"] = "Грешка в добавяне на адрес!";
return(Json(false));
}
if (!ModelState.IsValid)
{
TempData["ResultError"] = "Грешка в добавяне на адрес!";
return(Json(false));
}
using (var context = new AkcetModel())
{
var address = new Address();
address = modelAddress;
address.DateCreated = DateTime.Now;
address.DateModified = DateTime.Now;
address.UserName = User.Identity.Name;
address.UserID = User.Identity.GetUserId();
context.Addresses.Add(address);
context.SaveChanges();
TempData["ResultSuccess"] = "Успешно добавихте адрес!";
return(Json(new { id = address.IdAddress, value = address.StreetName }));
}
}
public ActionResult CreateCompanyAjax([Bind(Exclude = "UserId", Include = "CompanyID,UserId,IdAddress,CompanyName,CompanyMol,DdsNumber,CompanyDescription,CompanyPhone,IsPrimary,DateCreated,DateModified")] Company company)
{
ModelState.Remove("UserId");
if (!Request.IsAjaxRequest())
{
return(Json(false));
}
if (!ModelState.IsValid)
{
return(Json(false));
}
if (company.IdAddress == 0)
{
TempData["ResultError"] = "Не сте избрали адрес на фирмата!";
return(Json(false));
}
using (var context = new AkcetModel())
{
company.DateCreated = DateTime.Now;
company.DateModified = DateTime.Now;
company.UserId = User.Identity.GetUserId();
company.IsDeleted = false;
db.Companies.Add(company);
db.SaveChanges();
return(Json(new { id = company.CompanyID, value = company.CompanyName }));
}
}
public ActionResult Products_Read([DataSourceRequest] DataSourceRequest request)
{
using (var context = new AkcetModel())
{
var products = context.ProductInvoiceTemps;
DataSourceResult result = products.ToDataSourceResult(request);
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveProductAjax(string Products, string Dds, string Projects, string ProductPrice, string Quanity)
{
decimal productPrice;
decimal quantity;
if (String.IsNullOrWhiteSpace(Products))
{
return(Json(false));
}
if (String.IsNullOrWhiteSpace(Dds))
{
return(Json(false));
}
if (String.IsNullOrWhiteSpace(Projects))
{
return(Json(false));
}
if (String.IsNullOrWhiteSpace(ProductPrice) && !decimal.TryParse(ProductPrice, out productPrice))
{
return(Json(false));
}
if (String.IsNullOrWhiteSpace(Quanity) && !decimal.TryParse(Quanity, out quantity))
{
return(Json(false));
}
//TODO: If ProductPrice has ',' do something
//TODO: If Quantity has ',' do something
var userId = User.Identity.GetUserId();
ViewBag.Dds = new SelectList(db.DDS, "DdsId", "DdsName");
ViewBag.Products = new SelectList(db.Products.Where(p => p.UserId == userId && p.IsDeleted == false), "ProductID", "ProductName");
ViewBag.Projects = new SelectList(db.Projects.Where(m => m.UserID == userId && m.IsDeleted == false), "ProjectID", "ProjectName");
ViewBag.IsInsertedProduct = true;
var model = new ProductInvoiceTemp();
var firstOrDefault = db.FakturiTemps.Where(s => s.UserId == userId).OrderByDescending(x => x.DateCreated).FirstOrDefault();
if (firstOrDefault != null)
{
// var orDefault = db.DDS.FirstOrDefault(s => s.Value == Dds);
// if (orDefault != null)
// {
var tbl = new ProductInvoiceTemp()
{
InvoiceIDTemp = firstOrDefault.InvoiceIDTemp,
DdsID = Int32.Parse(Dds),
ProjectID = Int32.Parse(Projects),
ProductID = Int32.Parse(Products),
ProductPrice = Decimal.Parse(ProductPrice, CultureInfo.InvariantCulture),
Quanity = Decimal.Parse(Quanity, CultureInfo.InvariantCulture)
};
using (var context = new AkcetModel())
{
db.ProductInvoiceTemps.Add(tbl);
db.SaveChanges();
}
model.ProductInvoiceID = tbl.ProductInvoiceID;
// }
}
// model.ProductInvoiceID = Int32.Parse(Products);
return(PartialView("~/Views/Shared/InvoicesPartials/_TabProductsPartial.cshtml", model));
}
