//
// GET: /Contractor/Edit/Id
public ActionResult Edit(int id = 0)
{
ContractorModel model = null;
using (ContractorContext context = new ContractorContext())
{
model = context.GetContractor(id);
}
if (model == null)
{
return(RedirectToAction("Index"));
}
// Физическо лице
else if (model.ContractorTypeId == 1)
{
return(View("EditPerson", model));
}
// // Юридическо лице
else if (model.ContractorTypeId == 2)
{
return(View("EditCompany", model));
}
else
{
return(RedirectToAction("Index"));
}
}
// GET: Employe/Edit/5
public ActionResult Edit(int?id)
{
ContractorModel contractorModel = new ContractorModel();
InitializePageData();
if (!id.HasValue)
{
DisplayWarningMessage("Looks like, the Contractor ID is missing in your request");
return(View(contractorModel));
}
try
{
if (!contractService.Exists(id.Value))
{
DisplayWarningMessage($"Sorry, we couldn't find the Employee with ID: {id.Value}");
return(View(contractorModel));
}
ContractorDto contractor = contractService.GetByID(id.Value);
contractorModel = Mapper.Map <ContractorDto, ContractorModel>(contractor);
}
catch (Exception exp)
{
DisplayReadErrorMessage(exp);
}
return(View(contractorModel));
}
public static bool UpdateContractor(ContractorModel Obj)
{
using (var dbContext = new BSSDBEntities())
{
var Check = dbContext.tblContractorMasters.Where(x => x.ContractorCode == Obj.ContractorCode && x.DealerID == Obj.DealerID && x.AccountID == Obj.AccountID).FirstOrDefault();
if (Check != null)
{
Check.ContractorName = Obj.ContractorName;
Check.ContractorCode = Obj.ContractorCode;
Check.CreatedBy = Obj.CreatedBy;
Check.AccountID = Obj.AccountID;
Check.IsDeleted = false;
Check.Address = Obj.Address;
Check.Phone = Obj.Phone;
Check.CreationDate = DateTime.Now;
Check.DealerID = Obj.DealerID;
dbContext.Entry(Check).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public PartialViewResult DetailsContractor(long id)
{
var person = PersonRepository.GetItemById <Contractor>(id);
var contractor = new ContractorModel(person);
return(PartialView(contractor));
}
public static bool AddContractor(ContractorModel Obj)
{
using (var dbContext = new BSSDBEntities())
{
var Check = dbContext.tblContractorMasters.Where(x => x.ContractorCode == Obj.ContractorCode && x.DealerID == Obj.DealerID && x.AccountID == Obj.AccountID).FirstOrDefault();
if (Check == null)
{
tblContractorMaster Cm = new tblContractorMaster()
{
ContractorName = Obj.ContractorName,
ContractorCode = Obj.ContractorCode,
CreatedBy = Obj.CreatedBy,
AccountID = Obj.AccountID,
IsDeleted = false,
Address = Obj.Address,
Phone = Obj.Phone,
CreationDate = DateTime.Now,
DealerID = Obj.DealerID
};
dbContext.Entry(Cm).State = System.Data.Entity.EntityState.Added;
dbContext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public PartialViewResult EditContractor(long id)
{
var person = PersonRepository.GetItemById <Contractor>(id);
var items = new List <SelectListItem>();
var companies = CompanyRepository.GetAllCompanyNames();
//items.Add(new SelectListItem { Text = "No company", Value = "0" });
foreach (var comp in companies)
{
if (comp.CompanyNames == person.Company.CompanyName)
{
items.Add(new SelectListItem {
Text = comp.CompanyNames, Value = comp.Id.ToString(), Selected = true
});
}
else
{
items.Add(new SelectListItem {
Text = comp.CompanyNames, Value = comp.Id.ToString()
});
}
}
var contractor = new ContractorModel(person);
contractor.Companies = items;
return(PartialView(contractor));
}
public bool SaveContractor(ContractorModel contractor)
{
var saved = false;
try
{
var id = contractor.Id;
var data = _mapper.Map <Contractor>(contractor);
if (id <= 0)
{
//generate a random health status
data.HealthStatus = HealthStatus.GetRandomHealthStatusByProbability();
}
Context.Contractor.Add(data);
Context.SaveChanges();
saved = true;
}
catch (Exception ex)
{
saved = false;
}
return(saved);
}
public ActionResult Edit(ContractorModel model)
{
if (!ModelState.IsValid)
{
// Физическо лице
if (model.ContractorTypeId == 1)
{
return(View("EditPerson", model));
}
// // Юридическо лице
else if (model.ContractorTypeId == 2)
{
return(View("EditCompany", model));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
using (ContractorContext context = new ContractorContext())
{
context.Edit(model);
}
return(RedirectToAction("Index"));
}
}
public ContractorModel GetContractor(int id)
{
ContractorModel model = null;
string commandText =
@"SELECT cnt.ID AS CONTRACTOR_ID
, cnt.CONTRACTOR_TYPE_ID
, cnt.C_NAME
, cnt.ID_CONTRACTOR
, cnt.S_TOWN_ID
, cnt.C_ADDRESS
, ISNULL(c_cmp.ACCOUNTABLE_PERSON, '') AS ACCOUNTABLE_PERSON
FROM CONTRACTOR cnt
LEFT JOIN CONTRACTOR_COMPANY c_cmp ON c_cmp.CONTRACTOR_ID = cnt.ID
WHERE cnt.ID = " + SQLInt(id);
using (DataTable dtContractors = FillDataTable(commandText))
{
if (dtContractors.Rows.Count > 0)
{
DataRow drContractor = dtContractors.Rows[0];
model = new ContractorModel()
{
ContractorId = TryParse.ToInt32(drContractor["CONTRACTOR_ID"]),
Name = TryParse.ToString(drContractor["C_NAME"]),
ContractorTypeId = TryParse.ToInt32(drContractor["CONTRACTOR_TYPE_ID"]),
IdContractor = TryParse.ToString(drContractor["ID_CONTRACTOR"]),
TownId = TryParse.ToInt32(drContractor["S_TOWN_ID"]),
Address = TryParse.ToString(drContractor["C_ADDRESS"]),
AccountablePerson = TryParse.ToString(drContractor["ACCOUNTABLE_PERSON"])
};
}
}
return(model);
}
public ActionResult Edit(ContractorModel contractor)
{
try
{
InitializePageData();
if (ModelState.IsValid)
{
if (contractService.IsDuplicateContractorName(contractor.ContractorID, contractor.ContractorName))
{
DisplayWarningMessage("There is already a Contractor with the same Name");
return(View(contractor));
}
ContractorDto contractorDto = Mapper.Map <ContractorModel, ContractorDto>(contractor);
contractService.UpdateContractor(contractorDto);
DisplaySuccessMessage("Contractor details have been Updated successfully");
return(RedirectToAction("List"));
}
}
catch (Exception exp)
{
DisplayUpdateErrorMessage(exp);
}
return(View(contractor));
}
public ContractorPaymentPopup(MainLayout parentLayout, ContractorModel contractor)
{
InitializeComponent();
DataContext = this;
ParentLayout = parentLayout;
Contractor = contractor;
SetValues();
}
private async Task CreateContractor()
{
List <KeyValuePair <string, string> > values = new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("Name", ContractorName),
new KeyValuePair <string, string>("Phone", Phone),
new KeyValuePair <string, string>("Email", Email),
new KeyValuePair <string, string>("GSTN", GSTN),
new KeyValuePair <string, string>("WorkDescription", WorkDescription)
};
if (FieldValidation.ValidateFields(values))
{
CanSaveContractor = false;
try
{
ContractorModel contractorData = new ContractorModel()
{
Name = ContractorName,
Phone = phone,
Email = Email,
GSTN = GSTN,
WorkDescription = WorkDescription,
};
HttpResponseMessage result = null;
if (isUpdate)
{
contractorData.ID = ID;
contractorData.CreatedBy = SelectedContractor.CreatedBy;
contractorData.ModifiedOn = DateTime.Now;
contractorData.ModifiedBy = ParentLayout.LoggedInUser.Name;
result = await apiHelper.PutContractor(ParentLayout.LoggedInUser.Token, contractorData).ConfigureAwait(false);
}
else
{
contractorData.CreatedBy = ParentLayout.LoggedInUser.Name;
result = await apiHelper.PostContractor(ParentLayout.LoggedInUser.Token, contractorData).ConfigureAwait(false);
}
if (result.IsSuccessStatusCode)
{
MessageBox.Show($"Contractor Saved Successfully", "Success", MessageBoxButton.OK, MessageBoxImage.Information);
await GetContractors();
ClearFields();
}
else
{
MessageBox.Show("Error in saving Contractor", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
CanSaveContractor = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
CanSaveContractor = true;
}
}
}
public Guid Create([FromBody] ContractorModel model)
{
model.Id = Guid.NewGuid();
var contractor = _factory.Create(model.Id, Const.UserId);
contractor.CopyModelFields(model);
_repository.Save(contractor);
return(model.Id);
}
public static List <SpContractorWiseDtl_Result> GetContractorWiseDtl(ContractorModel obj)
{
List <SpContractorWiseDtl_Result> StatusResult = null;
using (var dbContext = new BSSDBEntities())
{
var ReqData = dbContext.SpContractorWiseDtl(obj.Contractor_Id, obj.DealerID, obj.AccountID);
StatusResult = ReqData.ToList();
}
return(StatusResult);
}
public IActionResult PostSaveContractor([FromBody] ContractorModel contractorDetail)
{
if (_contractorService.SaveContractor(contractorDetail))
{
return(Ok());
}
else
{
return(BadRequest());
}
}
internal override Task <object> GetInfo()
{
object result = null;
var item = Item;
result = new ContractorModel
{
ID = item.ID,
ShortName = item.ShortName
};
return(Task.FromResult(result));
}
public Guid Update(Guid id, [FromBody] ContractorModel model)
{
model.Id = id;
var contractor = _repository.GetById(id);
if (contractor == null)
{
return(Guid.Empty);
}
contractor.CopyModelFields(model);
_repository.Save(contractor);
return(contractor.Id);
}
public ActionResult NewCompany(ContractorModel model)
{
if (!ModelState.IsValid)
{
return(View("EditCompany", model));
}
else
{
using (ContractorContext context = new ContractorContext())
{
model.ContractorTypeId = 2; // Юридическо лице
context.Add(model);
}
return(RedirectToAction("Index"));
}
}
/// <summary>
/// Редактира контрагент
/// </summary>
public void Edit(ContractorModel model)
{
// Променя данните за контрагента
string commandText =
@"UPDATE CONTRACTOR
SET C_NAME = " + SQLString(model.Name) + @"
, ID_CONTRACTOR = " + SQLString(model.IdContractor) + @"
, S_TOWN_ID = " + SQLInt(model.TownId) + @"
, C_ADDRESS = " + SQLString(model.Address) + @"
WHERE ID = " + SQLInt(model.ContractorId);
ExecuteNonQuery(commandText);
// Записва разширена информация за контаргента
SaveExtension(model);
}
/// <summary>
/// Редактира контрагент
/// </summary>
public void Edit(ContractorModel model)
{
// Променя данните за контрагента
string commandText =
@"UPDATE CONTRACTOR
SET C_NAME = " + SQLString(model.Name) + @"
, ID_CONTRACTOR = " + SQLString(model.IdContractor) + @"
, S_TOWN_ID = " + SQLInt(model.TownId) + @"
, C_ADDRESS = " + SQLString(model.Address) + @"
WHERE ID = " + SQLInt(model.ContractorId);
ExecuteNonQuery(commandText);
// Записва разширена информация за контаргента
SaveExtension(model);
}
public static void CopyModelFields(this Contractor contractor, ContractorModel model)
{
contractor.Account = model.Account;
contractor.Address = model.Address;
contractor.City = model.City;
contractor.Comment = model.Comment;
contractor.Description = model.Description;
contractor.Email = model.Email;
contractor.FullName = model.FullName;
contractor.Name = model.Name;
contractor.Id = model.Id;
contractor.Index = model.Index;
contractor.Inn = model.Inn;
contractor.Kpp = model.Kpp;
contractor.Phone = model.Phone;
contractor.SiteUrl = model.SiteUrl;
}
public ActionResult CreateEdit(int id = 0)
{
ContractorModel model = new ContractorModel();
if (id > 0)
{
model = (new ContractorDB()).GetContractorbyId(id);
ViewBag.Action = "Edit";
}
else
{
ViewBag.Action = "Create";
}
return(View(model));
}
private void SelectionContractor()
{
JournalsForm journal = new JournalsForm();
JournalsPresenter <Contractor> presenter = new JournalsPresenter <Contractor>(journal, new ContractorJournal(journal.Grid));
journal.ShowDialog();
if (presenter.Info != null)
{
ContractorModel contractor = (ContractorModel)presenter.Info;
_contractorID = contractor.ID;
View.Contractor = contractor.ShortName;
View.EnabledContactPerson = true;
View.EnabledCar = true;
}
}
public async Task <HttpResponseMessage> PostContractor(string token, ContractorModel contractorData)
{
try
{
httpClient.DefaultRequestHeaders.Clear();
httpClient.DefaultRequestHeaders.Accept.Clear();
httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
httpClient.DefaultRequestHeaders.Add("Authorization", $"bearer {token}");
using (HttpResponseMessage response = await httpClient.PostAsJsonAsync("/api/Contractor", contractorData))
{
return(response);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public PartialViewResult CreateContractor()
{
var items = new List <SelectListItem>();
var companies = CompanyRepository.GetAllCompanyNames();
items.Add(new SelectListItem {
Text = "Select copmany", Value = "0", Selected = true
});
foreach (var comp in companies)
{
items.Add(new SelectListItem {
Text = comp.CompanyNames, Value = comp.Id.ToString()
});
}
var pers = new ContractorModel(items);
return(PartialView(pers));
}
public ActionResult EditContractor(long id, ContractorModel editedContractor)
{
if (ModelState.IsValid)
{
var newContractor = new ContractorDetailsDto();
editedContractor.ConvertToDto(newContractor);
var currentContractor = PersonRepository.GetItemById <Contractor>(id);
var currentAddress = AddressRepository.GetItemById <Address>(currentContractor.Address.Id);
AddressRepository.UpdateAddress(currentAddress, editedContractor.City, editedContractor.Street);
var newCompany = CompanyRepository.GetItemById <Company>(newContractor.CompanyId);
var currentsalary = PersonRepository.GetItemById <Salary>(currentContractor.Salary.Id);
PersonRepository.UpdateContractor(currentContractor, newContractor, newCompany, currentsalary);
var pers = PersonRepository.GetAllFirstAndLastNames();
return(PartialView("WorkerList", pers));
}
return(PartialView(editedContractor));
}
public ActionResult CreateContractor(ContractorModel newcontractor)
{
if (ModelState.IsValid)
{
var company = CompanyRepository.GetItemById <Company>(newcontractor.CompanyId);
var address = new Address(newcontractor.Street, newcontractor.City);
var skill = new Dictionary <string, int>();
var salary = new Salary(newcontractor.Salary, 0.0);
var contractor = ContractorFactory.CreateContractor(newcontractor.Firstname, newcontractor.Lastname,
newcontractor.BirthDate,
skill, address, company, newcontractor.WorkExp, salary);
PersonRepository.AddPerson(contractor);
var pers = PersonRepository.GetAllFirstAndLastNames();
return(PartialView("WorkerList", pers));
}
return(PartialView(newcontractor));
}
/// <summary>
/// Добавя контрагент
/// </summary>
public void Add(ContractorModel model)
{
// Добавя контрагент
string commandText =
@"INSERT INTO CONTRACTOR
( CONTRACTOR_TYPE_ID, C_NAME, ID_CONTRACTOR, S_TOWN_ID, C_ADDRESS )
VALUES (" + SQLInt(model.ContractorTypeId) +
", " + SQLString(model.Name) +
", " + SQLString(model.IdContractor) +
", " + SQLInt(model.TownId) +
", " + SQLString(model.Address) + @")
SELECT @@IDENTITY";
model.ContractorId = TryParse.ToInt32(ExecuteScalar(commandText));
// Записва разширена информация за контаргента
SaveExtension(model);
}
/// <summary>
/// Добавя контрагент
/// </summary>
public void Add(ContractorModel model)
{
// Добавя контрагент
string commandText =
@"INSERT INTO CONTRACTOR
( CONTRACTOR_TYPE_ID, C_NAME, ID_CONTRACTOR, S_TOWN_ID, C_ADDRESS )
VALUES (" + SQLInt(model.ContractorTypeId) +
", " + SQLString(model.Name) +
", " + SQLString(model.IdContractor) +
", " + SQLInt(model.TownId) +
", " + SQLString(model.Address) + @")
SELECT @@IDENTITY";
model.ContractorId = TryParse.ToInt32(ExecuteScalar(commandText));
// Записва разширена информация за контаргента
SaveExtension(model);
}
public ActionResult Create()
{
ContractorModel model = new ContractorModel
{
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(30)
};
try
{
InitializePageData();
}
catch (Exception exp)
{
DisplayLoadErrorMessage(exp);
}
return(View(model));
}
public static bool Delete(ContractorModel Obj)
{
using (var dbContext = new BSSDBEntities())
{
var Check = dbContext.tblContractorMasters.Where(x => x.Contractor_Id == Obj.Contractor_Id).FirstOrDefault();
if (Check != null)
{
Check.IsDeleted = true;
Check.ModifiedBy = Obj.ModifiedBy;
Check.ModifiedDate = DateTime.Now;
dbContext.Entry(Check).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public ActionResult Edit(ContractorModel model)
{
if (!ModelState.IsValid)
{
// Физическо лице
if (model.ContractorTypeId == 1)
{ return View("EditPerson", model); }
// // Юридическо лице
else if (model.ContractorTypeId == 2)
{ return View("EditCompany", model); }
else
{ return RedirectToAction("Index"); }
}
else
{
using (ContractorContext context = new ContractorContext())
{
context.Edit(model);
}
return RedirectToAction("Index");
}
}
public static ContractorModel GetModel(this Contractor contractor)
{
var model = new ContractorModel
{
Account = contractor.Account,
Address = contractor.Address,
City = contractor.City,
Comment = contractor.Comment,
Description = contractor.Description,
Email = contractor.Email,
FullName = contractor.FullName,
Name = contractor.Name,
Id = contractor.Id,
Index = contractor.Index,
Inn = contractor.Inn,
Kpp = contractor.Kpp,
Phone = contractor.Phone,
SiteUrl = contractor.SiteUrl
};
return(model);
}
public ActionResult NewCompany(ContractorModel model)
{
if (!ModelState.IsValid)
{
return View("EditCompany", model);
}
else
{
using (ContractorContext context = new ContractorContext())
{
model.ContractorTypeId = 2; // Юридическо лице
context.Add(model);
}
return RedirectToAction("Index");
}
}
//
// GET: /Contractor/NewCompany
public ActionResult NewCompany()
{
ContractorModel model = new ContractorModel();
return View("EditCompany", model);
}
public ContractorModel GetContractor(int id)
{
ContractorModel model = null;
string commandText =
@"SELECT cnt.ID AS CONTRACTOR_ID
, cnt.CONTRACTOR_TYPE_ID
, cnt.C_NAME
, cnt.ID_CONTRACTOR
, cnt.S_TOWN_ID
, cnt.C_ADDRESS
, ISNULL(c_cmp.ACCOUNTABLE_PERSON, '') AS ACCOUNTABLE_PERSON
FROM CONTRACTOR cnt
LEFT JOIN CONTRACTOR_COMPANY c_cmp ON c_cmp.CONTRACTOR_ID = cnt.ID
WHERE cnt.ID = " + SQLInt(id);
using (DataTable dtContractors = FillDataTable(commandText))
{
if( dtContractors.Rows.Count > 0)
{
DataRow drContractor = dtContractors.Rows[0];
model = new ContractorModel()
{
ContractorId = TryParse.ToInt32(drContractor["CONTRACTOR_ID"]),
Name = TryParse.ToString(drContractor["C_NAME"]),
ContractorTypeId = TryParse.ToInt32(drContractor["CONTRACTOR_TYPE_ID"]),
IdContractor = TryParse.ToString(drContractor["ID_CONTRACTOR"]),
TownId = TryParse.ToInt32(drContractor["S_TOWN_ID"]),
Address = TryParse.ToString(drContractor["C_ADDRESS"]),
AccountablePerson = TryParse.ToString(drContractor["ACCOUNTABLE_PERSON"])
};
}
}
return model;
}
/// <summary>
/// Записва разширена информация за контаргента
/// </summary>
private void SaveExtension(ContractorModel model)
{
if (model.ContractorId == 0)
{ return; }
// Ако е юридическо лице
if (model.ContractorTypeId == 2)
{
string commandText = String.Format(
@"UPDATE CONTRACTOR_COMPANY
SET ACCOUNTABLE_PERSON = {1}
WHERE CONTRACTOR_ID = {0}
IF @@ROWCOUNT = 0
BEGIN
INSERT INTO CONTRACTOR_COMPANY
(CONTRACTOR_ID, ACCOUNTABLE_PERSON)
VALUES ({0}, {1})
END ", SQLInt(model.ContractorId), SQLString(model.AccountablePerson));
ExecuteNonQuery(commandText);
}
}
