public void ShowDataInGrid()
{
DataTable dt;
dt = new DataTable();
switch (drpMastertable.SelectedItem.ToString())
{
case "Brand Master":
Brand_Masters Brand_Masters = new Brand_Masters();
IList <Brand_Master> ilistbrandMaster = Brand_Masters.GetBrand_Masters(txtCode.Text, txtName.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Brand_Master>(ilistbrandMaster);
bindBrandMaster(dt);
// grdMasterTable.DataSource = Brand_Masters.GetBrand_Masters(txtCode.Text, txtName.Text, drpSelectCompany.SelectedItem.Text);
//grdMasterTable.DataBind();
txtCode.Visible = true;
txtName.Visible = true;
lblName.Visible = true;
lblCode.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Cancellation Reason Code":
Cancellation_Reason_Codes Cancellation_Reason_Codes = new Cancellation_Reason_Codes();
//DataTable dt = new DataTable();
IList <Cancellation_Reason_Code> ilistCancelReasonCode = Cancellation_Reason_Codes.GetCancellation_Reason_Codes(txtCode.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Cancellation_Reason_Code>(ilistCancelReasonCode);
bindCancellationReasonCode(dt);
txtCode.Visible = true;
lblCode.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Customer Master":
Customers Customer = new Customers();
IList <Customer> ilistCustomer = Customer.GetCustomers(txtName.Text, txtCity.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Customer>(ilistCustomer);
bindCustomerMaster(dt);
txtName.Visible = true;
txtCity.Visible = true;
lblName.Visible = true;
lblCity.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Detention Setup":
Detention_Setups DetentionSetup = new Detention_Setups();
IList <Detention_Setup> ilistDetentionSetup = DetentionSetup.GetDetention_Setups(drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Detention_Setup>(ilistDetentionSetup);
bindDetentionSetup(dt);
break;
case "In-Transit Duration":
Transit_Durations Transit_Duration = new Transit_Durations();
IList <Transit_Duration> ilistTransitDuration = Transit_Duration.GetTransit_Durations(drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Transit_Duration>(ilistTransitDuration);
bindInTransitDuration(dt);
break;
case "Item Master":
Items item = new Items();
IList <Item> ilistItem = item.GetItems(drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Item>(ilistItem);
bindItemMaster(dt);
break;
case "Location Master":
Locations location = new Locations();
IList <Location> ilistLocation = location.GetLocations(txtName.Text, txtCode.Text, txtCity.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Location>(ilistLocation);
txtName.Visible = true;
txtCode.Visible = true;
txtCity.Visible = true;
lblCity.Visible = true;
lblCode.Visible = true;
lblName.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Payment Discount Scheme":
Payment_Discount_Schemes paymentDiscountScheme = new Payment_Discount_Schemes();
IList <Payment_Discount_Scheme> ilistPaymentDisScheme = paymentDiscountScheme.GetPayment_Discount_Schemes(txtCode.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Payment_Discount_Scheme>(ilistPaymentDisScheme);
bindPaymentDiscountScheme(dt);
txtCode.Visible = true;
lblCode.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Penalty Reason Code":
Penalty_Reason_Codes penaltyReasonCode = new Penalty_Reason_Codes();
IList <Penalty_Reason_Code> ilistPenaltyreasonCode = penaltyReasonCode.GetPenalty_Reason_Codes(txtCode.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Penalty_Reason_Code>(ilistPenaltyreasonCode);
bindPaneltyReasonCode(dt);
txtCode.Visible = true;
lblCode.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Placement Setup":
Placement_Setups placement = new Placement_Setups();
IList <Placement_Setup> ilistPlacementSetup = placement.GetPlacement_Setups(drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Placement_Setup>(ilistPlacementSetup);
bindPlacementSetup(dt);
break;
case "Rejection Reason Code":
Rejection_Reason_Codes rejectionReasonCode = new Rejection_Reason_Codes();
IList <Rejection_Reason_Code> ilistRejectionReasonCode = rejectionReasonCode.GetRejection_Reason_Codes(txtCode.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Rejection_Reason_Code>(ilistRejectionReasonCode);
bindRejectionReasonCode(dt);
txtCode.Visible = true;
lblCode.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Freight Master":
Shipping_Agent_Purch_PriceINs shippingAgent = new Shipping_Agent_Purch_PriceINs();
IList <Shipping_Agent_Purch_PriceIN> ilistShipping_Agent_Purch_PriceIN = shippingAgent.GetShipping_Agent_Purch_PriceINs(drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Shipping_Agent_Purch_PriceIN>(ilistShipping_Agent_Purch_PriceIN);
bindFreightMaster(dt);
break;
case "SKU Master":
SKU_Masters skuMaster = new SKU_Masters();
IList <SKU_Master> ilistSKU_Master = skuMaster.GetSKU_Masters(txtName.Text, txtCode.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <SKU_Master>(ilistSKU_Master);
bindSKUMaster(dt);
txtCode.Visible = true;
txtName.Visible = true;
lblCode.Visible = true;
lblName.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Transit Loss Charges":
Transit_Loss_Chargess transitLossCharge = new Transit_Loss_Chargess();
IList <Transit_Loss_Charges> ilistTransit_Loss_Chargess = transitLossCharge.GetTransit_Loss_Chargess(drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Transit_Loss_Charges>(ilistTransit_Loss_Chargess);
bindTransitLossCharge(dt);
break;
case "Unit of Measure":
Unit_of_Measures unitMeasure = new Unit_of_Measures();
IList <Unit_of_Measure> ilistUnit_of_Measure = unitMeasure.GetUnit_of_Measures(txtCode.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Unit_of_Measure>(ilistUnit_of_Measure);
bindUnitOfMeasure(dt);
txtCode.Visible = true;
lblCode.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "User Transporter Mapping":
User_Transporter_Mappings userTransporterMapping = new User_Transporter_Mappings();
IList <User_Transporter_Mapping> ilistUser_Transporter_Mapping = userTransporterMapping.GetUser_Transporter_Mappings(drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <User_Transporter_Mapping>(ilistUser_Transporter_Mapping);
bindUserTransporterMapping(dt);
break;
case "Vendor":
Vendors Vendor = new Vendors();
IList <Vendor> ilistVendor = Vendor.GetVendors(txtName.Text, txtCity.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Vendor>(ilistVendor);
bindVendor(dt);
txtName.Visible = true;
txtCity.Visible = true;
lblName.Visible = true;
lblCity.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "Whse Shipping Truck IN":
Whse_Shipping_Truck_INs whseShippingTruck = new Whse_Shipping_Truck_INs();
IList <Whse_Shipping_Truck_IN> ilistWhseShippingTruck_IN = whseShippingTruck.GetWhse_Shipping_Truck_INs(txtCode.Text, drpSelectCompany.SelectedItem.Text);
dt = ConvertTable.ToDataTable <Whse_Shipping_Truck_IN>(ilistWhseShippingTruck_IN);
bindWhseShippingTruckIN(dt);
txtCode.Visible = true;
lblCode.Visible = true;
btnGo.Visible = true;
//Added by Jyothi
btnExport.Visible = true;
break;
case "User":
Users user = new Users();
IList <User> ilistUsers = user.GetUsers();
dt = ConvertTable.ToDataTable <User>(ilistUsers);
bindUser(dt);
break;
default:
break;
}
}