public CompanyEL GetCompanyById(int CompanyId)
{
CompanyEL objCompanyEL = null;
SQLHelper objSQLHelper = new SQLHelper();
DataTable dt = objSQLHelper.ExecuteSelectProcedure("SelectCompanyById"
, objSQLHelper.SqlParam("@Company_Id", CompanyId, SqlDbType.Int)
);
if (dt != null && dt.Rows.Count > 0)
{
objCompanyEL = new CompanyEL();
objCompanyEL.Company_id = (int)dt.Rows[0]["company_Id"];
objCompanyEL.company_name = dt.Rows[0]["company_name"].ToString();
objCompanyEL.tin_no = dt.Rows[0]["tin_no"].ToString();
objCompanyEL.pan_no = dt.Rows[0]["pan_no"].ToString();
objCompanyEL.phone = dt.Rows[0]["phone"].ToString();
objCompanyEL.address1 = dt.Rows[0]["address1"].ToString();
objCompanyEL.city = dt.Rows[0]["city"].ToString();
objCompanyEL.state = dt.Rows[0]["state"].ToString();
objCompanyEL.pincode = dt.Rows[0]["pincode"].ToString();
objCompanyEL.email = dt.Rows[0]["email"].ToString();
objCompanyEL.phone = dt.Rows[0]["phone"].ToString();
objCompanyEL.Fax_No = dt.Rows[0]["Fax_No"].ToString();
objCompanyEL.delivery_at = dt.Rows[0]["delivery_at"].ToString();
}
return(objCompanyEL);
}
void BindControl()
{
try
{
CompanyEL objCompanyEL = DataGridViewSelectedCompany;
textAddress1.Text = objCompanyEL.address1;
textCity.Text = objCompanyEL.city;
textEmail.Text = objCompanyEL.email;
textFaxNo.Text = objCompanyEL.Fax_No;
textPan.Text = objCompanyEL.pan_no;
txtTin.Text = objCompanyEL.tin_no;
textPhone.Text = objCompanyEL.phone;
textpinCode.Text = objCompanyEL.pincode;
textState.Text = objCompanyEL.state;
textCompanyName.Text = objCompanyEL.company_name;
textDelivertAt.Text = objCompanyEL.delivery_at;
btnDelete.Visible = true;
btnUpdate.Visible = true;
btnSave.Visible = false;
}
catch
{
ControlClear();
}
}
public List <CompanyEL> GetCompanyList()
{
CompanyEL objCompanyEL;
List <CompanyEL> lstCompanyEL = new List <CompanyEL>();
SQLHelper objSQLHelper = new SQLHelper();
DataTable dt = objSQLHelper.ExecuteSelectProcedure("SelectCompanyAll");
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
objCompanyEL = new CompanyEL();
objCompanyEL.Company_id = (int)dt.Rows[i]["company_Id"];
objCompanyEL.company_name = dt.Rows[i]["company_name"].ToString();
objCompanyEL.tin_no = dt.Rows[i]["tin_no"].ToString();
objCompanyEL.pan_no = dt.Rows[i]["pan_no"].ToString();
objCompanyEL.phone = dt.Rows[i]["phone"].ToString();
objCompanyEL.address1 = dt.Rows[i]["address1"].ToString();
objCompanyEL.city = dt.Rows[i]["city"].ToString();
objCompanyEL.state = dt.Rows[i]["state"].ToString();
objCompanyEL.pincode = dt.Rows[i]["pincode"].ToString();
objCompanyEL.email = dt.Rows[i]["email"].ToString();
objCompanyEL.phone = dt.Rows[i]["phone"].ToString();
objCompanyEL.Fax_No = dt.Rows[i]["Fax_No"].ToString();
objCompanyEL.delivery_at = dt.Rows[i]["delivery_at"].ToString();
lstCompanyEL.Add(objCompanyEL);
}
}
return(lstCompanyEL);
}
public bool Update(CompanyEL objCompanyEL)
{
SQLHelper objSQLHelper = new SQLHelper();
SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans();
try
{
int Id = objSQLHelper.ExecuteUpdateProcedure("UpdateCompany", objSqlTransaction
, objSQLHelper.SqlParam("@tin_no", objCompanyEL.tin_no, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@company_name", objCompanyEL.company_name, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@address1", objCompanyEL.address1, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@pan_no", objCompanyEL.pan_no, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@city", objCompanyEL.city, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@state", objCompanyEL.state, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@pincode", objCompanyEL.pincode, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@email", objCompanyEL.email, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@phone", objCompanyEL.phone, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@Fax_No", objCompanyEL.Fax_No, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@company_id", objCompanyEL.Company_id, SqlDbType.Int)
, objSQLHelper.SqlParam("@delivery_at", objCompanyEL.delivery_at, SqlDbType.NVarChar)
);
objSqlTransaction.Commit();
return(true);
}
catch
{
objSqlTransaction.Rollback();
return(false);
}
}
public DataSet GetBillReportData(CompanyEL _CompanyEL, BillEL _BillEL)
{
SQLHelper objSQLHelper = new SQLHelper();
DataSet ds = new DataSet();
//DataTable dtBillBody = ds.Tables.Add("GetBillReportBody");
//DataTable dtBillHeader = ds.Tables.Add("GetBillReportHeader");
DataTable dtBillBody = objSQLHelper.ExecuteSelectProcedure("GetBillReportBody"
, objSQLHelper.SqlParam("@Bill_Id", _BillEL.Bill_Id, SqlDbType.Int)
, objSQLHelper.SqlParam("@Company_id", _CompanyEL.Company_id, SqlDbType.Int)
);
DataTable dtBillHeader = objSQLHelper.ExecuteSelectProcedure("GetBillReportHeader"
, objSQLHelper.SqlParam("@Bill_Id", _BillEL.Bill_Id, SqlDbType.Int)
, objSQLHelper.SqlParam("@Company_id", _CompanyEL.Company_id, SqlDbType.Int)
);
dtBillHeader.TableName = "GetBillReportHeader";
dtBillBody.TableName = "GetBillReportBody";
ds.Tables.Add(dtBillBody);
ds.Tables.Add(dtBillHeader);
return(ds);
}
public List <BillingDelivertDetailEL> GetUnProcessBillingDeliver(CompanyEL companyEL)
{
BillingDelivertDetailEL objBillingDelivertDetailEL;
List <BillingDelivertDetailEL> lstBillingDelivertDetail = new List <BillingDelivertDetailEL>();
SQLHelper objSQLHelper = new SQLHelper();
DataTable dt = objSQLHelper.ExecuteSelectProcedure("B_GetUnProcess_Billing_DeliverDeatil"
, objSQLHelper.SqlParam("@Company_id", companyEL.Company_id, SqlDbType.Int)
);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
objBillingDelivertDetailEL = new BillingDelivertDetailEL();
objBillingDelivertDetailEL.Challan_Billing_Quantity = Convert.ToInt32(dt.Rows[i]["Challan_Billing_Quantity"]);
objBillingDelivertDetailEL.Deliver_Quantity = Convert.ToInt32(dt.Rows[i]["Deliver_Quantity"]);
objBillingDelivertDetailEL.Delivery_Detail_Id = Convert.ToInt32(dt.Rows[i]["Delivery_Detail_Id"]);
objBillingDelivertDetailEL.Delivery_Id = Convert.ToInt32(dt.Rows[i]["Delivery_Id"]);
objBillingDelivertDetailEL.Delivery_No = dt.Rows[i]["Delivery_No"].ToString();
objBillingDelivertDetailEL.Delivery_Date = Convert.ToDateTime(dt.Rows[i]["Delivery_Date"]);
objBillingDelivertDetailEL.Item_Quantity = Convert.ToInt32(dt.Rows[i]["Item_Quantity"]);
objBillingDelivertDetailEL.Purchase_Order_Detail_Id = Convert.ToInt32(dt.Rows[i]["Purchase_Order_Detail_Id"]);
objBillingDelivertDetailEL.Purchases_Order_Id = Convert.ToInt32(dt.Rows[i]["Purchases_Order_Id"]);
objBillingDelivertDetailEL.Total_Deliver_Quantity = Convert.ToInt32(dt.Rows[i]["Total_Deliver_Quantity"]);
objBillingDelivertDetailEL.Purchases_Order_No = dt.Rows[i]["Purchases_Order_No"].ToString();
objBillingDelivertDetailEL.PURCHASES_ORDER_Date = Convert.ToDateTime(dt.Rows[i]["PURCHASES_ORDER_Date"]);
lstBillingDelivertDetail.Add(objBillingDelivertDetailEL);
}
}
return(lstBillingDelivertDetail);
}
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 BalanceSheet(CompanyEL _companyEL)
: this()
{
companyEL = _companyEL;
lbCompanyName.Text = companyEL.company_name;
FillListBox();
}
public BillList(CompanyEL _objCompanyEL)
: this()
{
this.companyEL = _objCompanyEL;
lblCompanyName.Text = companyEL.company_name;
GridBind();
}
public Bill_SubItem(BillItemEL _BillItemEL, CompanyEL _CompanyEL)
: this()
{
this._BillParentItem = _BillItemEL;
this.CompanyEL = _CompanyEL;
GridBind();
bindGridComboBox();
}
public PurchasesOrder(CompanyEL _companyEL)
: this()
{
this.companyEL = _companyEL;
lbCompanyName.Text = companyEL.company_name;
FillListBox();
ControlClear();
bindGridComboBox();
}
public BillingQuantityReportByPeriod(CompanyEL _objCompanyEL)
: this()
{
this.companyEL = _objCompanyEL;
lblCompanyName.Text = companyEL.company_name;
GetGlobalVariableData();
ItemGridBind();
}
public PurchasesDetailReport(CompanyEL _objCompanyEL, PurchaseOrderEL _PurchaseOrderEL)
: this()
{
this.companyEL = _objCompanyEL;
objPurchaseOrderEL = _PurchaseOrderEL;
lblCompanyName.Text = companyEL.company_name;
lblPurchasesOrderNo.Text = "Purchases Order No " + objPurchaseOrderEL.Purchases_Order_No;
GetGlobalVariableData();
ItemGridBind();
}
public BillReportViewer(CompanyEL _company, BillEL _BillEL)
: this()
{
companyEL = _company;
billEL = _BillEL;
GetGlobalVariableData();
BindComboBox();
CreateReport(" ");
}
public bool Delete(CompanyEL objCompanyEL)
{
SQLHelper objSQLHelper = new SQLHelper();
SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans();
try
{
int cpmpanyId = objSQLHelper.ExecuteDeleteProcedure("DeleteCompany", objSqlTransaction
, objSQLHelper.SqlParam("@company_id", objCompanyEL.Company_id, SqlDbType.Int)
);
objSqlTransaction.Commit();
return(true);
}
catch
{
objSqlTransaction.Rollback();
return(false);
}
}
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();
}
public DeliveryOrder(CompanyEL _companyEL, PurchaseOrderEL _purchaseOrderEL)
: this()
{
companyEL = _companyEL;
purchaseOrderEL = _purchaseOrderEL;
lbCompanyName.Text = companyEL.company_name;
lbPurchasesOrderNo.Text = purchaseOrderEL.Purchases_Order_No;
FillListBox();
if (Billing.Properties.Settings.Default.Challan_No_Mannual == 1)
{
textDeliveryOrderNo.ReadOnly = false;
}
else
{
textDeliveryOrderNo.ReadOnly = true;
}
}
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
{
}
}
private void Export(bool isExcel)
{
CompanyEL companyEL = SelectedCompany;
PurchaseOrderEL purchasesOrder = SelectedPurchasesOrder;
string filePath = @"\ExlPurchasesOrder.xlsx";
Common objCommon = new Common();
objCommon.PurchasesOrderExcelExport(dataGridView1
, saveFileDialog1
, filePath
, SelectedPurchasesOrder.Purchases_Order_No
, SelectedPurchasesOrder.Date.ToString("MMMM, dd yyyy")
, SelectedCompany.company_name
, SelectedCompany.address1
, SelectedCompany.city
, SelectedCompany.state
, SelectedCompany.pincode
, isExcel);
}
public Billing_MDI_Admin(CompanyEL _CompanyEL) : this()
{
companyEL = _CompanyEL;
this.Text = "Billing .... " + companyEL.company_name;
}
public ItemPrice(CompanyEL _CompanyEL)
: this()
{
companyEL = _CompanyEL;
GridBind();
}
public Challan_MDI_Admin(CompanyEL _CompanyEL)
: this()
{
companyEL = _CompanyEL;
this.Text = "Challan .... " + companyEL.company_name;
}
