public WorkOrder GetWorkOrder(int workOrderId)
{
WorkOrder workOrder = new WorkOrder();
using (IDataReader dr = new WorkOrderDataAdapter().GetWorkOrderById(workOrderId))
{
if (dr.Read())
{
workOrder = PopulateReader(dr);
}
dr.Close();
}
return workOrder;
}
public WorkOrderCollection GetTop5Materials()
{
WorkOrderCollection workOrderCollection = new WorkOrderCollection();
using (IDataReader dr = new WorkOrderDataAdapter().GetTop5Materials())
{
while (dr.Read())
{
WorkOrder workOrder = new WorkOrder();
workOrder.MaterialId = dr["MaterialId"].ToString();
workOrderCollection.Add(workOrder);
}
dr.Close();
}
return workOrderCollection;
}
public WorkOrderCollection GetTop5Customers()
{
WorkOrderCollection workOrderCollection = new WorkOrderCollection();
using (IDataReader dr = new WorkOrderDataAdapter().GetTop5Customers())
{
while (dr.Read())
{
WorkOrder workOrder = new WorkOrder();
workOrder.CustomerId = Convert.ToInt32(dr["CustomerId"]);
workOrderCollection.Add(workOrder);
}
dr.Close();
}
return workOrderCollection;
}
protected void btnSave_Click(object sender, EventArgs e)
{
WorkOrderModule workOrderModule = new WorkOrderModule();
InventorySystem.Business.WorkOrder workOrder = new InventorySystem.Business.WorkOrder();
if (ViewState["id"] == null)
{
workOrder.Id = workOrderModule.GetMaxId() + 1;
}
else
{
workOrder.Id = Convert.ToInt32(ViewState["id"]);
}
workOrder.CustomerId = Convert.ToInt32(ddlCustomers.SelectedValue);
workOrder.Description = txtDescription.Text;
workOrder.MaterialId = ddlMaterial.SelectedValue;
if (txtQuantity.Text != "")
workOrder.Quantity = Convert.ToInt32(txtQuantity.Text);
if (txtPatternCost.Text != "")
workOrder.PatternCost = Convert.ToDecimal(txtPatternCost.Text);
if (txtMachiningCost.Text != "")
workOrder.MachiningCost = Convert.ToDecimal(txtMachiningCost.Text);
if (txtCastingWeight.Text != "")
workOrder.CastingWeight = Convert.ToInt32(txtCastingWeight.Text);
workOrder.Others = txtOthers.Text;
if (txtModificationCost.Text != "")
workOrder.ModificationCost = Convert.ToDecimal(txtModificationCost.Text);
if (txtTotalCost.Text != "")
workOrder.TotalCost = Convert.ToDecimal(txtTotalCost.Text);
if (txtDescription.Text != "")
workOrder.DeliveryDateTime = Convert.ToDateTime(txtDeliveryDateTime.Text);
workOrder.Remarks = txtRemarks.Text;
workOrderModule.Save(workOrder);
gvWorkOrder.DataBind();
Helper.EnableControls(false, Helper.GetControlsInPlaceHolder("InfoPlaceHolder", Master));
btnSave.Enabled = false;
}
public void Save(WorkOrder workOrder)
{
workOrder.Save();
}
private WorkOrder PopulateReader(IDataReader dr)
{
WorkOrder workOrder = new WorkOrder();
if (dr["Id"] != DBNull.Value)
workOrder.Id = Convert.ToInt32(dr["Id"]);
workOrder.CustomerId = Convert.ToInt32(dr["CustomerId"]);
workOrder.Description = dr["Description"].ToString();
workOrder.MaterialId = dr["MaterialId"].ToString();
workOrder.Quantity = Convert.ToInt32(dr["Quantity"]);
workOrder.CastingWeight = Convert.ToInt32(dr["CastingWeight"]);
workOrder.PatternCost = Convert.ToDecimal(dr["PatternCost"]);
workOrder.MachiningCost = Convert.ToDecimal(dr["MachiningCost"]);
workOrder.ModificationCost = Convert.ToDecimal(dr["ModificationCost"]);
workOrder.TotalCost = Convert.ToDecimal(dr["TotalCost"]);
workOrder.Others = dr["Others"].ToString();
workOrder.DeliveryDateTime = Convert.ToDateTime(dr["DeliveryDateTime"]);
workOrder.Remarks = dr["Remarks"].ToString();
return workOrder;
}
public bool Update(WorkOrder workOrder)
{
return new WorkOrderDataAdapter().UpdateWorkOrder(workOrder.Id,
workOrder.CustomerId, workOrder.Description,
workOrder.MaterialId, workOrder.Quantity,
workOrder.CastingWeight, workOrder.PatternCost,
workOrder.MachiningCost, workOrder.ModificationCost,
workOrder.TotalCost, workOrder.Others, workOrder.DeliveryDateTime,
workOrder.Remarks);
}