private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (Common.MessageConfim("Are You Want To Delete This "))
{
CompanyEL objCompanyEL = new CompanyEL();
CompanyDL objCompanyDL = new CompanyDL();
objCompanyEL.Company_id = DataGridViewSelectedCompany.Company_id;
if (objCompanyDL.Delete(objCompanyEL))
{
Common.MessageDelete();
GridBind();
ControlClear();
}
else
{
}
}
}
catch
{
}
}
public void Actualiza(CompanyBE pItem)
{
try
{
CompanyDL Company = new CompanyDL();
Company.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public List <CompanyBE> ListaTodosActivo(int IdCompany)
{
try
{
CompanyDL Company = new CompanyDL();
return(Company.ListaTodosActivo(IdCompany));
}
catch (Exception ex)
{ throw ex; }
}
public void Inserta(CompanyBE pItem)
{
try
{
CompanyDL Company = new CompanyDL();
Company.Inserta(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(CompanyBE pItem)
{
try
{
CompanyDL Company = new CompanyDL();
Company.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public CompanyBE SeleccionaRuc(string Ruc)
{
try
{
CompanyDL Company = new CompanyDL();
CompanyBE objEmp = Company.SeleccionaRuc(Ruc);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public CompanyBE SeleccionaDescripcion(string RazonSocial)
{
try
{
CompanyDL Company = new CompanyDL();
CompanyBE objEmp = Company.SeleccionaDescripcion(RazonSocial);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public CompanyBE Selecciona(int IdCompany)
{
try
{
CompanyDL Company = new CompanyDL();
CompanyBE objEmp = Company.Selecciona(IdCompany);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public List <CompanyBE> ListaCombo()
{
try
{
CompanyDL Company = new CompanyDL();
List <CompanyBE> lista = Company.ListaCombo();
return(lista);
}
catch (Exception ex)
{ throw ex; }
}
public List <CompanyBE> SeleccionaTodos()
{
try
{
CompanyDL Company = new CompanyDL();
List <CompanyBE> lista = Company.SeleccionaTodos();
return(lista);
}
catch (Exception ex)
{ throw ex; }
}
void CompanyComboBox()
{
CompanyDL objCompanyDL = new CompanyDL();
List <CompanyEL> CompanyList = objCompanyDL.GetCompanyList();
cmbCompany.SelectedIndexChanged -= cmbCompany_SelectedIndexChanged;
cmbCompany.DataSource = CompanyList;
cmbCompany.DisplayMember = "company_name";
cmbCompany.ValueMember = "Company_id";
cmbCompany.SelectedIndexChanged += cmbCompany_SelectedIndexChanged;
}
void GridBind()
{
try
{
CompanyDL objCompanyDL = new CompanyDL();
PurchaseOrderDL _PurchaseOrderDL = new PurchaseOrderDL();
BillingDelivertDetailDL objBillingDelivertDetailDL = new BillingDelivertDetailDL();
List <CompanyEL> CompanyList = objCompanyDL.GetCompanyListByType(SelectedCompanyType);
dataGridView1.SelectionChanged -= dataGridView1_SelectionChanged;
dataGridView1.Click -= dataGridView1_Click;
dataGridView1.DataSource = CompanyList;
dataGridView1.Columns["Company_id"].Visible = false;
dataGridView1.Columns["Company_Type_Id"].Visible = false;
//BindControl();
dataGridView1.SelectionChanged += dataGridView1_SelectionChanged;
dataGridView1.Click += dataGridView1_Click;
#region SetGrid Color for panding bill creation
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
CompanyEL objCompanyEL = new CompanyEL();
objCompanyEL.Company_id = Convert.ToInt32(dataGridView1.Rows[i].Cells["company_Id"].Value);
List <BillingDelivertDetailEL> lstBillingDelivertDetail = objBillingDelivertDetailDL.GetUnProcessBillingDeliver(objCompanyEL);
lstBillingDelivertDetail = lstBillingDelivertDetail.Where(r => r.PURCHASES_ORDER_Date > Properties.Settings.Default.Create_Bill_Start_Date).ToList();
if (lstBillingDelivertDetail.Count > 0)
{
dataGridView1.Rows[i].DefaultCellStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(172)))), ((int)(((byte)(102)))), ((int)(((byte)(202)))));
dataGridView1.Rows[i].DefaultCellStyle.ForeColor = System.Drawing.Color.White;
}
}
#endregion
}
catch
{
}
ControlClear();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(textCompanyName.Text))
{
Common.MessageAlert("First Enter Company Name");
}
else
{
CompanyEL objCompanyEL = new CompanyEL();
CompanyDL objCompanyDL = new CompanyDL();
objCompanyEL.address1 = textAddress1.Text;
objCompanyEL.city = textCity.Text;
objCompanyEL.email = textEmail.Text;
objCompanyEL.Fax_No = textFaxNo.Text;
objCompanyEL.pan_no = textPan.Text;
objCompanyEL.tin_no = txtTin.Text;
objCompanyEL.phone = textPhone.Text;
objCompanyEL.pincode = textpinCode.Text;
objCompanyEL.state = textState.Text;
objCompanyEL.company_name = textCompanyName.Text;
objCompanyEL.Company_Type_Id = SelectedCompanyType;
objCompanyEL.delivery_at = textDelivertAt.Text;
if (objCompanyDL.Insert(objCompanyEL))
{
Common.MessageSave();
GridBind();
ControlClear();
}
else
{
}
}
}
catch
{
}
}
void GridBind()
{
try
{
CompanyDL objCompanyDL = new CompanyDL();
List <CompanyEL> CompanyList = objCompanyDL.GetCompanyList();
dataGridView1.SelectionChanged -= dataGridView1_SelectionChanged;
dataGridView1.Click -= dataGridView1_Click;
for (int i = 0; i < CompanyList.Count; i++)
{
dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells["Company_id"].Value = CompanyList[i].Company_id;
dataGridView1.Rows[i].Cells["company_name"].Value = CompanyList[i].company_name;
dataGridView1.Rows[i].Cells["tin_no"].Value = CompanyList[i].tin_no;
dataGridView1.Rows[i].Cells["pan_no"].Value = CompanyList[i].pan_no;
dataGridView1.Rows[i].Cells["phone"].Value = CompanyList[i].phone;
dataGridView1.Rows[i].Cells["address1"].Value = CompanyList[i].address1;
dataGridView1.Rows[i].Cells["city"].Value = CompanyList[i].city;
dataGridView1.Rows[i].Cells["state"].Value = CompanyList[i].state;
dataGridView1.Rows[i].Cells["pincode"].Value = CompanyList[i].pincode;
dataGridView1.Rows[i].Cells["email"].Value = CompanyList[i].email;
dataGridView1.Rows[i].Cells["phone"].Value = CompanyList[i].phone;
dataGridView1.Rows[i].Cells["Fax_No"].Value = CompanyList[i].Fax_No;
dataGridView1.Rows[i].Cells["delivery_at"].Value = CompanyList[i].delivery_at;
}
dataGridView1.Columns["Company_id"].Visible = false;
dataGridView1.SelectionChanged += dataGridView1_SelectionChanged;
dataGridView1.Click += dataGridView1_Click;
}
catch
{
}
ControlClear();
}
public IEnumerable <AddressBO> GetAddressesByType(int addressType)
{
DeliveryOrderDL dl = new DeliveryOrderDL();
var list = EnumExtensions.GetEnumValues <AddressType>();
List <AddressBO> returnList = new List <AddressBO>();
var specifiedType = list.FirstOrDefault(a => a.Value == addressType);
AddressType addType;
Enum.TryParse(specifiedType.Name, out addType);
switch (addType)
{
case AddressType.Customer:
{
var CustomerRepository = new CustomerRepository();
var allcustomers = CustomerRepository.GetAll();
foreach (var customer in allcustomers)
{
var addressBO = dl.GetAddress(customer.addrkey);
addressBO.AddrKey = customer.addrkey;
addressBO.Name = customer.custname;
returnList.Add(addressBO);
}
}
break;
case AddressType.Company:
{
var DL = new CompanyDL();
var companies = DL.GetCompanies();
foreach (var company in companies)
{
var addressBO = DL.GetAddress(company.addrkey);
addressBO.AddrKey = company.addrkey;
addressBO.Name = company.compname;
returnList.Add(addressBO);
}
}
break;
case AddressType.ShippingPort:
{
var shippingRepo = new ShippingPortRepository();
var allPorts = shippingRepo.GetAll();
foreach (var port in allPorts)
{
var addressBO = dl.GetAddress(port.addrkey);
addressBO.AddrKey = port.addrkey;
addressBO.Name = port.shippingportid;
returnList.Add(addressBO);
}
}
break;
case AddressType.Terminal:
{
var shippingRepo = new TerminalRepository();
var allPorts = shippingRepo.GetAll();
foreach (var port in allPorts)
{
var addressBO = dl.GetAddress(port.addrkey);
addressBO.AddrKey = port.portkey;
returnList.Add(addressBO);
}
}
break;
case AddressType.Warehouse:
{
var shippingRepo = new WarehouseRepository();
var allPorts = shippingRepo.GetAll();
foreach (var port in allPorts)
{
var addressBO = dl.GetAddress(port.addrkey);
addressBO.AddrKey = port.warehousekey;
addressBO.Name = port.warehouseid;
returnList.Add(addressBO);
}
}
break;
case AddressType.Vendor:
{
var repo = new VendorRepository();
var allPorts = repo.GetAll();
foreach (var port in allPorts)
{
var addressBO = dl.GetAddress(port.addrkey);
addressBO.AddrKey = port.vendkey;
addressBO.Name = port.vendname;
returnList.Add(addressBO);
}
}
break;
}
return(returnList);
}
