internal static bool UpdateContract(CommonContract oldPartner)
{
DatabaseEntities entities = new DatabaseEntities();
Partner dbPartner = entities.Partners.FirstOrDefault(p => p.PartnerId == oldPartner.PartnerId);
if (dbPartner == null)
{
return(false);
}
dbPartner.CompanyName = oldPartner.CompanyName;
dbPartner.Address = oldPartner.Address;
dbPartner.Email = oldPartner.Email;
dbPartner.Phone = oldPartner.Phone;
dbPartner.VATNumber = oldPartner.VatNumber;
dbPartner.Bulstat = oldPartner.Bulstat;
entities.Partners.Attach(dbPartner);
var entry = entities.Entry(dbPartner);
entry.Property(e => e.CompanyName).IsModified = true;
entry.Property(e => e.Address).IsModified = true;
entry.Property(e => e.Email).IsModified = true;
entry.Property(e => e.Phone).IsModified = true;
entry.Property(e => e.VATNumber).IsModified = true;
entry.Property(e => e.Bulstat).IsModified = true;
entities.SaveChanges();
return(true);
}
internal static List <CommonContract> GetAllPartners(String search)
{
DatabaseEntities entities = new DatabaseEntities();
List <Partner> allDbPartners = new List <Partner>();
if (search.IsEmpty())
{
allDbPartners = entities.Partners.ToList();
}
else
{
allDbPartners = entities.Partners.Where(p => p.CompanyName.Contains(search)).ToList();
}
List <CommonContract> allPartners = new List <CommonContract>();
foreach (var dbPartner in allDbPartners)
{
CommonContract contract = new CommonContract();
contract.PartnerId = dbPartner.PartnerId;
contract.Address = dbPartner.Address;
contract.Bulstat = dbPartner.Bulstat;
contract.PartnerType = dbPartner.PartnerType;
contract.Sum = dbPartner.Sum.Value;
contract.CompanyName = dbPartner.CompanyName;
contract.Email = dbPartner.Email;
contract.Phone = dbPartner.Phone;
contract.VatNumber = dbPartner.VATNumber;
allPartners.Add(contract);
}
return(allPartners);
}
internal static Guid CreateContract(CommonContract contract)
{
try
{
DatabaseEntities entities = new DatabaseEntities();
Partner p = new Partner();
p.CompanyName = contract.CompanyName;
p.Address = contract.Address;
p.Email = contract.Email;
p.Phone = contract.Phone;
p.VATNumber = contract.VatNumber;
p.Bulstat = contract.Bulstat;
Guid tempGuid = Guid.NewGuid();
p.PartnerId = tempGuid;
p.Sum = 0;
p.PartnerType = 0;
entities.Partners.Add(p);
entities.SaveChanges();
return(tempGuid);
}
catch (Exception e)
{
return(Guid.Empty);
}
}
public static async Task <CommonContract> GetPartnersById(String search)
{
CommonContract contracts = new CommonContract();
HttpResponseMessage response;
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(DataHolder.ServerAddress);
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic");
try
{
response = await client.GetAsync("api/contract/get/" + search);
}
catch (HttpRequestException ex)
{
throw new Exception(ex.InnerException.Message);
}
if (response.IsSuccessStatusCode)
{
return(await response.Content.ReadAsAsync <CommonContract>());
}
}
return(null);
}
public static async Task <bool> PostUpdateContract(CommonContract contract)
{
HttpResponseMessage response;
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(DataHolder.ServerAddress);
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic");
try
{
response = await client.PostAsJsonAsync("api/contract/update", contract);
}
catch (HttpRequestException ex)
{
throw new Exception(ex.InnerException.Message);
}
if (response.IsSuccessStatusCode)
{
return(true);
}
return(await response.Content.ReadAsAsync <bool>());
}
}
// private void tbSearchContracts_KeyDown(object sender, KeyEventArgs e)
// {
// if (e.KeyCode != Keys.Enter)
// {
// return;
// }
//
// LoadDataContracts();
// }
private async void btnEditContract_Click(object sender, EventArgs e)
{
if (dgvContracts.SelectedRows.Count == 1 && dgvContracts.SelectedRows[0] != null)
{
CommonContract selectedItem = (CommonContract)dgvContracts.SelectedRows[0].DataBoundItem;
List <CommonMol> mols = await SAOwner.getAllMols(selectedItem.PartnerId);
CommonMol mol = mols.Count == 0 ? new CommonMol() : mols.First();
AddEditContractForm form = new AddEditContractForm(selectedItem, mol);
if (form.ShowDialog() == DialogResult.OK)
{
LoadDataContracts();
}
}
}
public AddEditContractForm(CommonContract c, CommonMol m)
{
InitializeComponent();
contract = c;
mol = m;
tbAdressContract.Text = contract.Address;
tbBulstatNumberContract.Text = contract.Bulstat;
tbCompanyNameContract.Text = contract.CompanyName;
tbEmailContract.Text = contract.Email;
tbPhoneContract.Text = contract.Phone;
tbVatNumberContract.Text = contract.VatNumber;
tbAdressMolContract.Text = mol.Address;
tbEmailMolContract.Text = mol.Email;
tbFirstNameMol.Text = mol.FirstName;
tbLastNameMol.Text = mol.LastName;
tbPhoneMolContract.Text = mol.Phone;
}
public ActionResult LeaveForm(Guid Id)
{
var dto = new LeaveDto {
CreatorUserId = Operator.UserId, CreatorUserName = Operator.UserName
};
if (Guid.Empty != Id)
{
var model = FormContract.Leaves.Where(c => c.Id == Id).Select(m => new { m.TypeVal, m.Reason, m.StartTime, m.EndTime, m.CreatorUserId, m.CreatedTime }).FirstOrDefault();
dto.Id = Id;
dto.CreatorUserId = model.CreatorUserId;
dto.TypeVal = model.TypeVal;
dto.Reason = model.Reason;
}
dto.StartTime = dto.StartTime == DateTime.MinValue ? DateTime.Now : dto.StartTime;
dto.EndTime = dto.EndTime == DateTime.MinValue ? DateTime.Now : dto.EndTime;
dto.TypeHtml = CommonContract.GetDropdownOptionHtml("QJLX");
return(View(dto));
}
internal static CommonContract GetPartnersById(String search)
{
DatabaseEntities entities = new DatabaseEntities();
Partner dbPartner = entities.Partners.Find(new Guid(search));
if (dbPartner != null)
{
CommonContract contract = new CommonContract();
contract.PartnerId = dbPartner.PartnerId;
contract.Address = dbPartner.Address;
contract.Bulstat = dbPartner.Bulstat;
contract.PartnerType = dbPartner.PartnerType;
contract.Sum = dbPartner.Sum.Value;
contract.CompanyName = dbPartner.CompanyName;
contract.Email = dbPartner.Email;
contract.Phone = dbPartner.Phone;
contract.VatNumber = dbPartner.VATNumber;
return(contract);
}
return(null);
}
public bool PostUpdatePartner([FromBody] CommonContract contract)
{
return(BLContract.UpdateContract(contract));
}
public Guid PostCreatePartner([FromBody] CommonContract contract)
{
return(BLContract.CreateContract(contract));
}
