private void btnNew_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
DataTable source = gridControl1.DataSource as DataTable;
source.Clear();
gridControl1.DataSource = source;
txtLocation.Text = "";
txtRequester.Text = "";
datePOdate.EditValue = DateTime.Now;
Test.Purchase.database.PurchaseRequest pr = new Purchase.database.PurchaseRequest();
pr.FnConn();
DataTable dt1 = pr.FillData("M", "");
if (dt1.Rows.Count > 0)
{
number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1;
string invoiceno = number + "";
txtPRNo.Text = "PR-NO:" + invoiceno.PadLeft(5, '0');
}
btnSave.Enabled = true;
}
catch (Exception)
{
}
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
btnSave.Enabled = false;
gridControl1.RefreshDataSource();
DataTable source = gridControl1.DataSource as DataTable;
var emptyrows = source.AsEnumerable()
.All(r => r.ItemArray.All(x => x == DBNull.Value));
if (!emptyrows && txtLocation.Text.Length != 0 && txtPRNo.Text.Length != 0 && txtRequester.Text.Length != 0)
{
DataTable dt = new DataTable();
dt.Clear();
dt.Columns.Add("prNo");
dt.Columns.Add("requester");
dt.Columns.Add("location");
dt.Columns.Add("date");
dt.Rows.Add(new object[] { txtPRNo.Text, txtRequester.Text, txtLocation.Text, datePOdate.Text });
Test.Purchase.database.PurchaseRequest purchase = new Purchase.database.PurchaseRequest(source, dt);
purchase.FnConn();
if (btnSave.Caption == "Save")
{
purchase.fnTransactionData("I", txtPRNo.Text);
purchase.updatStatus("updateStatus", txtPRNo.Text, "PR Created");
}
else
{
purchase.fnTransactionData("U", txtPRNo.Text);
}
purchase.FnTrans();
MessageBox.Show("PR CREATED.", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void Purchase_Requst_List_Load(object sender, EventArgs e)
{
Purchase.database.PurchaseRequest purchaseRequest = new Purchase.database.PurchaseRequest();
purchaseRequest.FnConn();
DataTable dt = purchaseRequest.FillData("rqdetails", "");
if (dt.Rows.Count > 0)
{
gridControl1.DataSource = dt;
}
}
public void loadData()
{
Purchase.database.PurchaseRequest purchaseRequest = new Purchase.database.PurchaseRequest();
purchaseRequest.FnConn();
DataTable dt = purchaseRequest.FillData("rqdetails", "");
if (dt.Rows.Count > 0)
{
gridControl1.DataSource = dt;
}
purchaseRequest.FnTrans();
}
private void New_RFQ_Load(object sender, EventArgs e)
{
Test.Purchase.database.Rfq pr = new Purchase.database.Rfq();
pr.FnConn();
DataTable dt1 = pr.FillData("M", "");
DataTable dt = new DataTable();
if (dt1.Rows.Count > 0)
{
int number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1;
string invoiceno = number + "";
txtRFQNO.Text = "RFQ-NO:" + invoiceno.PadLeft(5, '0');
}
dt.Columns.Add("slno", Type.GetType("System.Int32"));
dt.Columns.Add("description", Type.GetType("System.String"));
dt.Columns.Add("brand", Type.GetType("System.String"));
dt.Columns.Add("quantity", Type.GetType("System.Int32"));
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
gridControl1.DataSource = dt;
cmbVendor1.Properties.Items.Clear();
cmbVendor2.Properties.Items.Clear();
cmbVendor3.Properties.Items.Clear();
DataTable dtc1 = pr.FillData("SC", "");
foreach (DataRow dr1 in dtc1.Rows)
{
cmbVendor1.Properties.Items.Add(dr1["name"] + "");
cmbVendor2.Properties.Items.Add(dr1["name"] + "");
cmbVendor3.Properties.Items.Add(dr1["name"] + "");
}
String res = pr.FnTrans();
Test.Purchase.database.PurchaseRequest pr1 = new Purchase.database.PurchaseRequest();
pr1.FnConn();
DataTable dtd = pr1.FillData("updatedata", no);
DataTable dtg = pr1.FillData("updategrd", no);
gridControl1.DataSource = dtg;
txtPO.Text = dtd.Rows[0]["prNo"].ToString();
Test.Commen_Form.Functions.DateConverter c = new Commen_Form.Functions.DateConverter();
dateRFQdate.EditValue = c.dateconverter(dtd.Rows[0]["date"] + "");
txtLocation.Text = dtd.Rows[0]["location"] + "";
}
private void gridView1_ShownEditor(object sender, EventArgs e)
{
Test.Purchase.database.PurchaseRequest po = new Purchase.database.PurchaseRequest();
if (gridView1.FocusedColumn.FieldName.Equals("itemNo"))//Don't work only for this column
{
TextEdit currentEditor = (sender as GridView).ActiveEditor as TextEdit;
if (currentEditor != null)
{
AutoCompleteStringCollection customSource = new AutoCompleteStringCollection();
po.FnConn();
DataTable dt = po.FillData("itemcode", "");
string res = po.FnTrans();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
customSource.Add(dt.Rows[i][0].ToString());
}
}
currentEditor.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
currentEditor.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
currentEditor.MaskBox.AutoCompleteCustomSource = customSource;
}
}
else if (gridView1.FocusedColumn.FieldName.Equals("description"))//Don't work only for this column
{
TextEdit currentEditor = (sender as GridView).ActiveEditor as TextEdit;
if (currentEditor != null)
{
AutoCompleteStringCollection customSource = new AutoCompleteStringCollection();
po.FnConn();
DataTable dt = po.FillData("itemname", "");
string res = po.FnTrans();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
customSource.Add(dt.Rows[i][0].ToString());
}
}
currentEditor.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
currentEditor.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
currentEditor.MaskBox.AutoCompleteCustomSource = customSource;
}
}
}
private void gridView1_HiddenEditor(object sender, EventArgs e)
{
try
{
int slno = gridView1.GetFocusedDataSourceRowIndex();
Test.Purchase.database.PurchaseRequest pr = new Purchase.database.PurchaseRequest();
System.Data.DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle);
row["slno"] = (slno + 1) + "";
if (gridView1.FocusedColumn.FieldName.Equals("itemNo"))
{
String itemcode = row["itemNo"].ToString();
if (itemcode != "")
{
pr.FnConn();
DataTable dt = pr.FillData("itemdetails", itemcode);
if (dt.Rows.Count > 0)
{
row["description"] = dt.Rows[0]["itemName"].ToString();
row["brand"] = dt.Rows[0]["brandName"].ToString();
row["quantity"] = "1";
}
}
}
else if (gridView1.FocusedColumn.FieldName.Equals("description"))
{
String description = row["description"].ToString();
if (description != "")
{
pr.FnConn();
DataTable dt = pr.FillData("desdetails", description);
if (dt.Rows.Count > 0)
{
row["itemNo"] = dt.Rows[0]["productCode"].ToString();
row["brand"] = dt.Rows[0]["brandName"].ToString();
row["quantity"] = "1";
}
}
}
}
catch (Exception)
{
}
}
private void Purchase_Requst_Load(object sender, EventArgs e)
{
Test.Purchase.database.PurchaseRequest pr = new Purchase.database.PurchaseRequest();
pr.FnConn();
if (flag == true)
{
btnSave.Caption = "Update";
DataTable dt = pr.FillData("updatedata", no);
DataTable dt1 = pr.FillData("updategrd", no);
gridControl1.DataSource = dt1;
txtLocation.Text = dt.Rows[0]["location"] + "";
txtPRNo.Text = dt.Rows[0]["prNo"] + "";
txtRequester.Text = dt.Rows[0]["requester"] + "";
Test.Commen_Form.Functions.DateConverter c = new Commen_Form.Functions.DateConverter();
datePOdate.EditValue = c.dateconverter(dt.Rows[0]["date"] + "");
}
else
{
btnSave.Caption = "Save";
DataTable dt1 = pr.FillData("M", "");
String res = pr.FnTrans();
DataTable dt = new DataTable();
if (dt1.Rows.Count > 0)
{
number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1;
string invoiceno = number + "";
txtPRNo.Text = "PR/" + invoiceno.PadLeft(5, '0');
}
dt.Columns.Add("slno", Type.GetType("System.Int32"));
dt.Columns.Add("itemNo", Type.GetType("System.String"));
dt.Columns.Add("description", Type.GetType("System.String"));
dt.Columns.Add("brand", Type.GetType("System.String"));
dt.Columns.Add("quantity", Type.GetType("System.Int32"));
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
gridControl1.DataSource = dt;
datePOdate.EditValue = DateTime.Now;
}
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
btnSave.Enabled = false;
gridControl1.RefreshDataSource();
DataTable source = gridControl1.DataSource as DataTable;
DataTable dt = new DataTable();
dt.Clear();
dt.Columns.Add("RFQNo");
dt.Columns.Add("ourchaseOrderNo");
dt.Columns.Add("date");
dt.Columns.Add("requester");
dt.Columns.Add("vendor1");
dt.Columns.Add("address1");
dt.Columns.Add("ph1");
dt.Columns.Add("vendor2");
dt.Columns.Add("address2");
dt.Columns.Add("ph2");
dt.Columns.Add("vendor3");
dt.Columns.Add("address3");
dt.Columns.Add("ph3");
dt.Columns.Add("vendoeId1");
dt.Columns.Add("vendoeId2");
dt.Columns.Add("vendoeId3");
dt.Columns.Add("location");
dt.Columns.Add("ststus");
dt.Rows.Add(new object[] { txtRFQNO.Text, txtPO.Text, dateRFQdate.Text, txtRequster.Text, cmbVendor1.Text, txtAddress1.Text, txtPh1.Text, cmbVendor2.Text, txtAddress2.Text, txtPh2.Text, cmbVendor3.Text, txtAddress3.Text, txtPh3.Text, vendorId1, vendorId2, vendorId3, txtLocation.Text, "RFQ Created" });
Test.Purchase.database.Rfq rfq = new Purchase.database.Rfq(source, dt);
rfq.FnConn();
rfq.fnTransactionData();
rfq.FnTrans();
MessageBox.Show("Request for Quotation Created.", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Information);
Test.Purchase.database.PurchaseRequest purchase = new Purchase.database.PurchaseRequest(source, dt);
purchase.FnConn();
purchase.updatStatus("updateStatus", txtPO.Text, "RFQ ISSUED");
purchase.FnTrans();
}
