}// SearchDocument (string s1)
// GET:
public ActionResult Details(int id)
{
using (DB_DocumentsEntities dbModel = new DB_DocumentsEntities())
{
return(View(dbModel.Firms.Where(f => f.IdFirm == id).FirstOrDefault()));
}
}//Detail
public string AjaxList()
{
using (DB_DocumentsEntities dbModel = new DB_DocumentsEntities())
{
int offset = int.Parse(Request["offset"] != null ? Request["offset"] : "0");
int limit = int.Parse(Request["limit"] != null ? Request["limit"] : "2");
var firms = dbModel.Firms
.OrderBy(f => f.IdFirm)
.Skip(offset)
.Take(limit)
.Select((f) => new
{
FirmTitle = f.TitleFirm,
DirectorSurname = f.Directors.Surname,
DirectorName = f.Directors.Name,
DirectorSecondName = f.Directors.SecondName,
Id = f.IdFirm
})
.ToList();
//offset++;
return(JsonConvert.SerializeObject(new
{ Firms = firms, }));
}
} // AjaxList()
public string DeleteCotract(string s1)
{
try
{
using (DB_DocumentsEntities dbModel = new DB_DocumentsEntities())
{
string СontractNumber = Request["СontractNumber"];
string ProviderTitle = Request["ProviderTitle"];
var resultTable = dbModel.Contracts.Where(x => x.Providers.Any(pr => pr.TitleProvider == ProviderTitle) && x.ContractNumber == СontractNumber).FirstOrDefault();
int Id1 = resultTable.IdContract;
dbModel.Contracts.Remove(dbModel.Contracts.FirstOrDefault(con => con.IdContract == Id1));
dbModel.SaveChanges();
return(JsonConvert.SerializeObject("{status: '200'}"));
}//using
}
catch (Exception ex)
{
return($"{{status: '500', message: '{ex.Message}'}}");
/*501 Not Implemented («не реализовано»);
* 500 Internal Server Error («внутренняя ошибка сервера»)
*/
}
}// DeleteCotract
}//GetItemsProvider
public ActionResult GetItemsContract(int id)
{
DB_DocumentsEntities dbModel = new DB_DocumentsEntities();
var cont = dbModel.Providers.FirstOrDefault(c => c.IdProvider == id).Contracts.ToList();
return(PartialView(cont));
}//GetItemsContract
// GET: Contract/Create
public ActionResult CreateCotract()
{
DB_DocumentsEntities dbModel = new DB_DocumentsEntities();
ViewBag.provider = dbModel.Providers;
return(View());
}//CreateCotract
public string CreateCotract(string s1)
{
try
{
using (DB_DocumentsEntities dbModel = new DB_DocumentsEntities())
{
string dateFromResult;
string dateEndResult;
string Year1 = Request["Year1"];
string Month1 = Request["Month1"];
string Day1 = Request["Day1"];
string Year2 = Request["Year2"];
string Month2 = Request["Month2"];
string Day2 = Request["Day2"];
int IdProvider = int.Parse(Request["firm"]);
dateFromResult = Year1 + "-" + Month1 + "-" + Day1;
dateEndResult = Year2 + "-" + Month2 + "-" + Day2;
Contracts contract = new Contracts()
{
ContractNumber = Request["СontractNumber"],
DateFrom = DateTime.Parse(dateFromResult),
DateEnd = DateTime.Parse(dateEndResult),
DeliveryConditionsIncoterms = Request["Incoterms"]
};
int providerID = int.Parse(Request["firm"]);
Providers pr = dbModel.Providers.FirstOrDefault(p => p.IdProvider == providerID);
contract.Providers.Add(pr);
dbModel.Contracts.Add(contract);
dbModel.SaveChanges();
return(JsonConvert.SerializeObject("{status: '200'}"));
}//using
}
catch (Exception ex)
{
return($"{{status: '500', message: '{ex.Message}'}}");
/*501 Not Implemented («не реализовано»);
* 500 Internal Server Error («внутренняя ошибка сервера»)
*/
}
}//CreateCotract
public ActionResult GetItemsProvider(int id)
{
DB_DocumentsEntities dbModel = new DB_DocumentsEntities();
var pr2 = dbModel.Firms.FirstOrDefault(p => p.IdFirm == id).Providers.ToList();
return(PartialView(pr2));
}//GetItemsProvider
public ActionResult Edit(int id, Firms firm)
{
try {
using (DB_DocumentsEntities dbModel = new DB_DocumentsEntities())
{
dbModel.Entry(firm).State = EntityState.Modified;
dbModel.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}// Edit
public ActionResult Edit(int id)
{
try{
using (DB_DocumentsEntities dbModel = new DB_DocumentsEntities()){
var resultTable = from f in dbModel.Firms
join d in dbModel.Directors on f.IdDirector equals d.IdDirector
join al in dbModel.Addresses on f.IdAddressLegal equals al.IdAddress
join aa in dbModel.Addresses on f.IdAddressActual equals aa.IdAddress
select new
{
idFirm = f.IdFirm,
titleFirm = f.TitleFirm,
Country1 = al.Country,
City1 = al.City,
Street1 = al.Street,
HouseNumber1 = al.HouseNumber,
OfficeNumber1 = al.OfficeNumber,
Country2 = aa.Country,
City2 = aa.City,
Street2 = aa.Street,
HouseNumber2 = aa.HouseNumber,
OfficeNumber2 = aa.OfficeNumber,
surname = d.Surname,
name = d.Name,
secondNamee = d.SecondName
};
return(View(resultTable.Where(r => r.idFirm == id).FirstOrDefault()));
}
}
catch
{
return(View("status: 500"));
}
}// Edit
