private void Save()
{
BindingSource bslistSP = (BindingSource)dgvOrder.DataSource;
BindingList <OrderDetail> listSP = (BindingList <OrderDetail>)bslistSP.DataSource;
int orderNo = getMaxOrdernumber();
using (entities = new SilverEntities())
{
//Adding in Receipt
DAL.Model.CustomerOrderInfo objOrder = new DAL.Model.CustomerOrderInfo();
int totalQty = 0;
foreach (OrderDetail lineItemModel in listSP)
{
lineItemModel.orderNo = orderNo;
entities.OrderDetails.Add(lineItemModel);
totalQty += Int32.Parse(lineItemModel.qty.ToString());
}
objOrder.orderNo = getMaxOrdernumber();
objOrder.orderDate = dtDate.Value;
objOrder.orderDeliveryDate = dtDeliveryDate.Value;
objOrder.lcode = Convert.ToString(myColumnComboBox.ValueMember);
objOrder.orderTotalQty = totalQty;
objOrder.metalType = Convert.ToString(cmbMetal.SelectedValue);
objOrder.metalRate = Decimal.Parse(txtMetalRate.Text);
objOrder.remark = txtRemark.Text.Trim();
entities.CustomerOrderInfoes.Add(objOrder);
entities.SaveChanges();
}
ResetForm();
ResetAfterSave();
}
private void btnDeleteC_Click(object sender, EventArgs e)
{
try
{
using (entities = new DAL.Model.SilverEntities())
{
if (!string.IsNullOrEmpty(txtCustCode.Text) && !string.IsNullOrEmpty(txtCustName.Text))
{
var custExist = entities.CustomerMs.FirstOrDefault(cust => cust.Code == txtCustCode.Text.Trim());
if (custExist != null)
{
entities.Entry(custExist).State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
MessageBox.Show("Data Deleted Successfully.", "Product");
this.LoadGridData();
this.ModifyCancel("modify");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.ToString(), "Error");
}
}
private void Save()
{
using (entities = new DAL.Model.SilverEntities())
{
if (!string.IsNullOrEmpty(txtMetalDesc.Text))
{
var metalExist = entities.MetalMs.FirstOrDefault(metal => metal.MetalDesc == txtMetalDesc.Text.Trim());
if (metalExist != null)
{
entities.Entry(metalExist).State = System.Data.Entity.EntityState.Modified;
metalExist.MetalDesc = txtMetalDesc.Text.Trim();
}
else
{
DAL.Model.MetalM obj = new DAL.Model.MetalM();
obj.MetalDesc = txtMetalDesc.Text.Trim();
entities.MetalMs.Add(obj);
}
entities.SaveChanges();
this.LoadGridData();
this.ModifyCancel("modify");
MessageBox.Show("Data Saved Successfully.", "Product");
}
}
}
private void Save()
{
using (entities = new DAL.Model.SilverEntities())
{
if (!string.IsNullOrEmpty(txtItemCode.Text) && !string.IsNullOrEmpty(txtProdName.Text))
{
var prodExist = entities.ProductMs.FirstOrDefault(prod => prod.ItemCode == txtItemCode.Text.Trim());
if (prodExist != null)
{
entities.Entry(prodExist).State = System.Data.Entity.EntityState.Modified;
prodExist.ItemCode = txtItemCode.Text.Trim();
prodExist.PName = txtProdName.Text.Trim();
}
else
{
DAL.Model.ProductM obj = new DAL.Model.ProductM();
obj.ItemCode = txtItemCode.Text.Trim();
obj.PName = txtProdName.Text.Trim();
entities.ProductMs.Add(obj);
}
entities.SaveChanges();
this.LoadGridData();
this.ModifyCancel("modify");
MessageBox.Show("Data Saved Successfully.", "Product");
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
using (entities = new DAL.Model.SilverEntities())
{
var orderQry = (from co in entities.CustomerOrderInfoes select co);
if (dtFromDate.Value != null)
{
orderQry = orderQry.Where(co => co.orderDate.Value >= dtFromDate.Value);
}
if (dtToDate.Value != null)
{
orderQry = orderQry.Where(co => co.orderDate.Value <= dtToDate.Value);
}
if (cmbCustomer.SelectedIndex >= 0)
{
orderQry = orderQry.Where(co => co.lcode.Equals(cmbCustomer.ValueMember.ToString()));
}
dgModify.DataSource = orderQry.ToList();
}
}
private void Reset()
{
dtToDate.Value = DateTime.Today;
dtFromDate.Value = DateTime.Today.AddDays(-10);
using (entities = new DAL.Model.SilverEntities())
{
var receipts = (from rcpt in entities.Receipts orderby rcpt.VNo descending select rcpt).Take(10);
dgModify.DataSource = receipts.ToList();
}
}
private void Reset()
{
dtToDate.Value = DateTime.Today;
dtFromDate.Value = DateTime.Today.AddDays(-10);
using (entities = new DAL.Model.SilverEntities())
{
var issues = (from issue in entities.Issues orderby issue.VNo descending select issue).Take(10);
dgModify.DataSource = issues.ToList();
}
}
private void LoadGridData()
{
using (entities = new DAL.Model.SilverEntities())
{
var datasource = from row in entities.MetalMs select row;
dataGrid.DataSource = datasource.ToList();
dataGrid.Columns["ID"].Visible = false;
dataGrid.Columns["MetalDesc"].HeaderText = "Description";
}
}
public void loadDataByOrderNo(int orderNo)
{
using (entities = new DAL.Model.SilverEntities())
{
var gridData = (
from ordDetail in entities.OrderDetails
where ordDetail.orderNo == orderNo
select ordDetail).ToList();
var bindingListSP = new BindingList <OrderDetail>(gridData);
var sourceSP = new BindingSource(bindingListSP, null);
dgvOrder.DataSource = null;
dgvOrder.DataSource = sourceSP;
dgvOrder.Columns["TID"].Visible = false;
dgvOrder.Columns["Lcode"].Visible = false;
dgvOrder.Columns["KID"].Visible = false;
dgvOrder.Columns["artisanReqDate"].Visible = false;
dgvOrder.Columns["orderPlacedDate"].Visible = false;
dgvOrder.Columns["orderRecdDate"].Visible = false;
dgvOrder.Columns["JobNo"].Visible = false;
dgvOrder.Columns["orderType"].Visible = false;
dgvOrder.Columns["orderNo"].Visible = false;
dgvOrder.Columns["orderDate"].Visible = false;
dgvOrder.Columns["PCode"].HeaderText = "Item Name";
dgvOrder.Columns["Qty"].HeaderText = "Quantity";
dgvOrder.Columns["Weight"].HeaderText = "Weight";
dgvOrder.Columns["TotalWeight"].HeaderText = "Total Weight";
var orderDetail = (from ordDetail in entities.CustomerOrderInfoes
where ordDetail.orderNo == orderNo
select ordDetail).ToList();
if (orderDetail != null)
{
CustomerOrderInfo orderInfo = orderDetail[0];
String custCode = orderInfo.lcode;
var customerInfo = (from custInfo in entities.CustomerMs where custInfo.Code.Equals(custCode) select custInfo).ToList();
txtMetalRate.Text = orderInfo.metalRate.ToString();
dtDate.Value = orderInfo.orderDate.Value;
dtDeliveryDate.Value = orderInfo.orderDeliveryDate.Value;
txtRemark.Text = orderInfo.remark;
myColumnComboBox.ValueMember = customerInfo[0].Code;
DataTable table = (DataTable)myColumnComboBox.Data;
DataRow[] foundRows = table.Select("Code = '" + customerInfo[0].Code + "'");
if (foundRows.Length > 0)
{
int SelectedIndex = table.Rows.IndexOf(foundRows[0]);
myColumnComboBox.SelectedIndex = SelectedIndex;
}
calculateTotalWeight();
}
}
}
public Issue(int vNo = 0, bool edit = false)
{
this.voucherNo = vNo;
this.modify = edit;
InitializeComponent();
entities = new SilverEntities();
ResetForm();
if (this.modify)
{
this.btnModify.Text = "Cancel";
this.btnDelete.Visible = true;
}
}
private void populateCustomerDetail()
{
using (entities = new DAL.Model.SilverEntities())
{
List <CustomerM> custSource = (from cust in entities.CustomerMs orderby cust.CustName select cust).ToList();
// var metalSource = (from metal in entities.MetalMs orderby metal.MetalDesc).ToList();
// custSource
DataTable datatable = MiscUtils.ToDataTable <CustomerM>(custSource);
var metalSource = entities.MetalMs.OrderBy((x) => x.MetalDesc).ToList();
cmbMetal.DataSource = metalSource;
cmbMetal.DisplayMember = "MetalDesc";
cmbMetal.ValueMember = "ID";
var itemSource = entities.ProductMs.OrderBy((x) => x.PName).ToList();
cmbProductCode.DataSource = itemSource;
cmbProductCode.DisplayMember = "Pname";
cmbProductCode.ValueMember = "ItemCode";
//txtOrderNo.Text = getMaxOrdernumber().ToString();
LoadComboBox(datatable);
var gridData = (
from ordDetail in entities.OrderDetails
where ordDetail.orderNo == orderNo
select ordDetail).ToList();
var bindingListSP = new BindingList <OrderDetail>(gridData);
var sourceSP = new BindingSource(bindingListSP, null);
dgvOrder.DataSource = null;
dgvOrder.DataSource = sourceSP;
dgvOrder.Columns["TID"].Visible = false;
dgvOrder.Columns["Lcode"].Visible = false;
dgvOrder.Columns["KID"].Visible = false;
dgvOrder.Columns["artisanReqDate"].Visible = false;
dgvOrder.Columns["orderPlacedDate"].Visible = false;
dgvOrder.Columns["orderRecdDate"].Visible = false;
dgvOrder.Columns["JobNo"].Visible = false;
dgvOrder.Columns["orderType"].Visible = false;
dgvOrder.Columns["orderNo"].Visible = false;
dgvOrder.Columns["orderDate"].Visible = false;
dgvOrder.Columns["PCode"].HeaderText = "Item Name";
dgvOrder.Columns["Qty"].HeaderText = "Quantity";
dgvOrder.Columns["Weight"].HeaderText = "Weight";
dgvOrder.Columns["TotalWeight"].HeaderText = "Total Weight";
}
}
private void LoadGridData()
{
using (entities = new DAL.Model.SilverEntities())
{
var datasource = from row in entities.CustomerMs where row.CustType.Equals("D") select row;
dataGrid.DataSource = datasource.ToList();
dataGrid.Columns["ID"].Visible = false;
dataGrid.Columns["CustType"].Visible = false;
dataGrid.Columns["Code"].HeaderText = "Code";
dataGrid.Columns["CustName"].HeaderText = "Customer Name";
dataGrid.Columns["Phone"].HeaderText = "Phone";
dataGrid.Columns["Email"].HeaderText = "Email";
dataGrid.Columns["PAN"].HeaderText = "PAN";
dataGrid.Columns["CustAddress"].HeaderText = "Address";
}
}
private int getMaxOrdernumber()
{
using (var localentities = new DAL.Model.SilverEntities())
{
var maxOrder = localentities.OrderDetails.Max(p => (int?)p.orderNo);
if (maxOrder == null)
{
return(1);
}
else
{
return(maxOrder.Value + 1);
}
}
}
private void LoadGridData()
{
using (entities = new DAL.Model.SilverEntities())
{
var datasource = from row in entities.ProductMs select row;
dataGrid.DataSource = datasource.ToList();
dataGrid.Columns["ID"].Visible = false;
dataGrid.Columns["ItemCode"].HeaderText = "Product Code";
dataGrid.Columns["PName"].HeaderText = "Product Name";
//if (datasource.ToList().Count > 0)
//{
// var stone = datasource.ToList().FirstOrDefault();
// this.selectedID = stone.ID;
// this.txtItemCode.Text = stone.ItemCode;
// this.txtProdName.Text = stone.PName;
//}
}
}
private void Reset()
{
dtToDate.Value = DateTime.Today;
dtFromDate.Value = DateTime.Today.AddDays(-10);
using (entities = new DAL.Model.SilverEntities())
{
var orderInfo = (from co in entities.CustomerOrderInfoes orderby co.orderNo descending select co).Take(10);
dgModify.DataSource = orderInfo.ToList();
dgModify.Columns[5].Visible = false;
dgModify.Columns[6].Visible = false;
dgModify.Columns[7].Visible = false;
dgModify.Columns[8].Visible = false;
List <CustomerM> custSource = (from cust in entities.CustomerMs orderby cust.CustName select cust).ToList();
DataTable datatable = MiscUtils.ToDataTable <CustomerM>(custSource);
LoadComboBox(datatable);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
using (entities = new DAL.Model.SilverEntities())
{
//if (chkDatewise.Checked)
//{
// var receipts = (from rcpt in entities.Receipts where (rcpt.VDate.Value >= dtFromDate.Value && rcpt.VDate.Value <= dtToDate.Value) orderby rcpt.VNo select rcpt);
// dgModify.DataSource = receipts.ToList();
//}
//else if (chkProductwise.Checked)
//{
// decimal dFrom = decimal.Parse(txtNetWtFrom.Text);
// decimal dTo = decimal.Parse(txtNetWtTo.Text);
// var receipts = (from rcpt in entities.Receipts
// .Where(x=>x.LCode.Contains(txtCustName.Text.Trim()) ||
// (x.NetWt >= dFrom && x.NetWt <=dTo )) orderby rcpt.VNo descending select rcpt);
// dgModify.DataSource = receipts.ToList();
//}
//else
//{
// var receipts = (from rcpt in entities.Receipts orderby rcpt.VNo descending select rcpt).Take(10);
// dgModify.DataSource = receipts.ToList();
//}
decimal dFrom = decimal.Parse(txtNetWtFrom.Text);
decimal dTo = decimal.Parse(txtNetWtTo.Text);
var receipts = (from rcpt in entities.Receipts
.Where(x => (x.VDate.Value >= dtFromDate.Value && x.VDate.Value <= dtToDate.Value) || x.LCode.Contains(txtCustName.Text.Trim()) ||
(x.NetWt >= dFrom && x.NetWt <= dTo))
orderby rcpt.VNo descending
select rcpt);
}
dgModify.Columns["ID"].Visible = false;
//dgvSP.Columns["SeqNo"].HeaderText = "Seq No";
//dgvSP.Columns["TDate"].HeaderText = "Date";
//dgvSP.Columns["PCode"].HeaderText = "Item Name";
//dgvSP.Columns["BarCode"].HeaderText = "Bar Code";
//dgvSP.Columns["MetalType"].HeaderText = "Metal";
//dgvSP.Columns["InType"].HeaderText = "Type";
}
private void btnSearch_Click(object sender, EventArgs e)
{
using (entities = new DAL.Model.SilverEntities())
{
decimal dFrom = 0, dTo = 0;
decimal.TryParse(txtNetWtFrom.Text, out dFrom);
decimal.TryParse(txtNetWtTo.Text, out dTo);
var issues = (from issue in entities.Issues
.Where(x => (x.VDate.Value >= dtFromDate.Value && x.VDate.Value <= dtToDate.Value) || x.LCode.Contains(txtCustName.Text.Trim()) ||
(x.NetWt >= dFrom && x.NetWt <= dTo))
orderby issue.VNo descending
select issue);
dgModify.DataSource = issues.ToList();
}
dgModify.Columns["ID"].Visible = false;
//dgvSP.Columns["SeqNo"].HeaderText = "Seq No";
//dgvSP.Columns["TDate"].HeaderText = "Date";
//dgvSP.Columns["PCode"].HeaderText = "Item Name";
//dgvSP.Columns["BarCode"].HeaderText = "Bar Code";
//dgvSP.Columns["MetalType"].HeaderText = "Metal";
//dgvSP.Columns["InType"].HeaderText = "Type";
}
private void Save()
{
using (entities = new DAL.Model.SilverEntities())
{
if (!string.IsNullOrEmpty(txtCustCode.Text) && !string.IsNullOrEmpty(txtCustName.Text))
{
var custExist = entities.CustomerMs.FirstOrDefault(cust => cust.Code == txtCustCode.Text.Trim());
if (custExist != null)
{
entities.Entry(custExist).State = System.Data.Entity.EntityState.Modified;
custExist.Code = txtCustCode.Text.Trim();
custExist.CustName = txtCustName.Text.Trim();
custExist.Phone = txtPhone.Text.Trim();
custExist.Email = txtEmail.Text.Trim();
custExist.PAN = txtPAN.Text.Trim();
custExist.CustAddress = txtAddress.Text.Trim();
}
else
{
DAL.Model.CustomerM obj = new DAL.Model.CustomerM();
obj.Code = txtCustCode.Text.Trim();
obj.CustName = txtCustName.Text.Trim();
obj.Phone = txtPhone.Text.Trim();
obj.Email = txtEmail.Text.Trim();
obj.PAN = txtPAN.Text.Trim();
obj.CustAddress = txtAddress.Text.Trim();
obj.CustType = "D";
entities.CustomerMs.Add(obj);
}
entities.SaveChanges();
this.LoadGridData();
this.ModifyCancel("modify");
MessageBox.Show("Data Saved Successfully.", "Product");
}
}
}
