public void Delete(CustomerAccountant accountant)
{
_customerAccountantDal.Delete(accountant);
}
private void tbtnSave_ItemClick(object sender, TileItemEventArgs e)
{
ExceptionHandler.HandleException(() =>
{
if (frmMain.customerIdx != 0)
{
#region Update
var updateCustomer = new Customer
{
CustomerId = customerInfo.CustomerId,
CustomerCode = txtCode.Text,
CustomerName = txtName.Text,
CustomerTaxNo = txtTaxNo.Text,
CustomerTaxDepartment = txtTaxDepart.Text,
CustomerAddress = txtAddress.Text,
CustomerActive = chbActive.Checked,
CustomerDebated = chbDebate.Checked,
CustomerGotAppointment = chbAppointment.Checked,
CustomerEnvoyId = Convert.ToInt32(cmbEnvoy.EditValue)
};
var updateDirector = new CustomerDirector
{
DirectorId = customerDirector.DirectorId,
DirectorName = txtDirectorName.Text,
DirectorTitle = txtDirectorTitle.Text,
DirectorGsm = txtDirectorGsm.Text,
DirectorMail = txtDirectorMail.Text,
DirectorPhone = txtDirectorPhone.Text,
CustomerId = updateCustomer.CustomerId
};
var updatePurchasingStaff = new CustomerPurchasingStaff
{
PurchaseStaffId = customerPurchStaff.PurchaseStaffId,
PurchaseStaffName = txtPurchasingDirector.Text,
PurchaseStaffGsm = txtPurchasingGsm.Text,
PurchaseStaffMail = txtPurchasingMail.Text,
PurchaseStaffPhone = txtPurchasingPhone.Text,
CustomerId = updateCustomer.CustomerId
};
var updateAccountant = new CustomerAccountant
{
AccountantId = customerAccountant.AccountantId,
CustomerId = updateCustomer.CustomerId,
AccountantName = txtAccountantName.Text,
AccountantGsm = txtAccountantGsm.Text,
AccountantMail = txtAccountantMail.Text,
AccountantPhone = txtAccountantPhone.Text,
AccountantExpiry = dtpAccountantExpiry.DateTime
};
_customerService.UpdateWithTransaction(updateCustomer, updateAccountant, updateDirector, updatePurchasingStaff);
FillCustomerInfo();
XtraMessageBox.Show("Güncellendi.");
#endregion
}
else
{
#region NewRecord
var newCustomerRec = new Customer
{
CustomerCode = txtCode.Text,
CustomerName = txtName.Text,
CustomerTaxNo = txtTaxNo.Text,
CustomerTaxDepartment = txtTaxDepart.Text,
CustomerAddress = txtAddress.Text,
CustomerActive = chbActive.Checked,
CustomerDebated = chbDebate.Checked,
CustomerGotAppointment = chbAppointment.Checked,
CustomerEnvoyId = Convert.ToInt32(cmbEnvoy.EditValue)
};
var newDirectorRec = new CustomerDirector
{
DirectorName = txtDirectorName.Text,
DirectorTitle = txtDirectorTitle.Text,
DirectorGsm = txtDirectorGsm.Text,
DirectorMail = txtDirectorMail.Text,
DirectorPhone = txtDirectorPhone.Text,
};
var newPurchasingStaffRec = new CustomerPurchasingStaff
{
PurchaseStaffName = txtPurchasingDirector.Text,
PurchaseStaffGsm = txtPurchasingGsm.Text,
PurchaseStaffMail = txtPurchasingMail.Text,
PurchaseStaffPhone = txtPurchasingPhone.Text,
};
var newAccountantRec = new CustomerAccountant
{
AccountantName = txtAccountantName.Text,
AccountantGsm = txtAccountantGsm.Text,
AccountantMail = txtAccountantMail.Text,
AccountantPhone = txtAccountantPhone.Text,
AccountantExpiry = dtpAccountantExpiry.DateTime
};
_customerService.AddWithTransaction(newCustomerRec, newAccountantRec, newDirectorRec, newPurchasingStaffRec);
frmMain.customerIdx = newCustomerRec.CustomerId;
FillCustomerInfo();
tbarDetails.Visible = true;
XtraMessageBox.Show("Başarıyla Oluşturuldu.");
#endregion
}
});
}
public void Add(CustomerAccountant accountant)
{
_customerAccountantDal.Add(accountant);
}
public void ImportXl(string path, ICustomerService customerService)
{
try
{
string xlConn = string
.Format($"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={path};Extended Properties=\"Excel 12.0;HDR=NO;\"");
using (OleDbConnection xconn = new OleDbConnection(xlConn))
{
OleDbCommand xcmd = new OleDbCommand("select * from [Sayfa1$]", xconn);
OleDbDataReader xdr;
xconn.Open();
xdr = xcmd.ExecuteReader();
while (xdr.Read())
{
importedCustomer = new Customer
{
CustomerCode = xdr[0].ToString(),
CustomerName = xdr[1].ToString(),
CustomerTaxNo = xdr[2].ToString(),
CustomerTaxDepartment = xdr[3].ToString(),
CustomerAddress = xdr[4].ToString()
};
importedDirector = new CustomerDirector
{
CustomerId = importedCustomer.CustomerId,
DirectorName = xdr[5].ToString(),
DirectorTitle = xdr[6].ToString(),
DirectorGsm = xdr[7].ToString(),
DirectorMail = xdr[8].ToString(),
DirectorPhone = xdr[9].ToString()
};
importedStaff = new CustomerPurchasingStaff {
CustomerId = importedCustomer.CustomerId,
PurchaseStaffName = xdr[10].ToString(),
PurchaseStaffGsm = xdr[11].ToString(),
PurchaseStaffMail = xdr[12].ToString(),
PurchaseStaffPhone = xdr[13].ToString()
};
importedAccountant = new CustomerAccountant
{
CustomerId = importedCustomer.CustomerId,
AccountantName = xdr[14].ToString(),
AccountantGsm = xdr[15].ToString(),
AccountantMail = xdr[16].ToString(),
AccountantPhone = xdr[17].ToString(),
AccountantExpiry = Convert.ToDateTime(xdr[18], CultureInfo.GetCultureInfo("tr-TR").DateTimeFormat)
};
customerService.AddWithTransaction(importedCustomer, importedAccountant, importedDirector, importedStaff);
}
xconn.Close();
}
}
catch (Exception exception)
{
throw new Exception($"Hata {importedCustomer.CustomerName} " +
exception.Message + "\r Hatalı kayıt Silindi.");
}
}
