public ActionResult NewWorkorder(ssmtbl_WorkorderModel objWoMod)
{
try
{
if (ModelState.IsValid)
{
string result = objWoData.InsertWorkorder(objWoMod);
if (result == "Workorder Created Successfully!")
{
ModelState.Clear();
objWoMod = new ssmtbl_WorkorderModel();
objWoMod.WorkorderNo = objWoData.GetMaxWorkorderNo();
objWoMod.DateOfIssue = DateTime.Now;
objWoMod.TargetDate = DateTime.Now;
objWoMod.ProductionStartDate = DateTime.Now;
@ViewBag.HideClass = "alert alert-success";
@ViewBag.Message = result;
}
else
{
@ViewBag.HideClass = "alert alert-danger";
@ViewBag.Message = result;
}
}
}
catch (Exception ex)
{
Global.ErrorHandlerClass.LogError(ex);
@ViewBag.HideClass = "alert alert-danger";
@ViewBag.Message = "Workorder Not Saved!";
}
return(View(objWoMod));
}
public List <ssmtbl_WorkorderModel> GetWoDataByPO(string po = "")
{
List <ssmtbl_WorkorderModel> objWoList = new List <ssmtbl_WorkorderModel>();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_getInquiryfrompoid";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ponumber", po);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_WorkorderModel objtemp = new ssmtbl_WorkorderModel();
objtemp.CutWeight = (sdr["cutweight"].ToString());
objtemp.HeatCode = (sdr["FeasibilityHeattreatment"].ToString());
objtemp.ColorCode = (sdr["ColorCode"].ToString());
objtemp.RawMaterial = (sdr["RawMaterial"].ToString());
objtemp.Section = (sdr["Section"].ToString());
objtemp.PoRM = (sdr["PORM"].ToString());
objtemp.PoSection = (sdr["Section"].ToString());
objWoList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objWoList);
}
public List <ssmtbl_WorkorderModel> GetAllWorkorder()
{
List <ssmtbl_WorkorderModel> objWoList = new List <ssmtbl_WorkorderModel>();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_Get_AllWorkorder";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Select");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_WorkorderModel objtemp = new ssmtbl_WorkorderModel();
objtemp.WorkorderID = Convert.ToInt32(sdr["WorkorderID"].ToString());
objtemp.WorkorderNo = sdr["WorkorderNo"].ToString();
objtemp.PlanQty = Convert.ToDecimal(sdr["PlanQty"].ToString());
objtemp.TargetDate = Convert.ToDateTime(sdr["TargetDate"].ToString());
objtemp.CreatedDate = Convert.ToDateTime(sdr["CreatedDate"].ToString());
objWoList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objWoList);
}
public List <ssmtbl_WorkorderModel> GetWorkorderApprovalList(string woStatus)
{
List <ssmtbl_WorkorderModel> objList = new List <ssmtbl_WorkorderModel>();
try
{
string sqlstr = "uspRMApproval";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "SelectWoList");
cmd.Parameters.AddWithValue("@WorkorderStatus", woStatus.Trim());
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_WorkorderModel objModel = new ssmtbl_WorkorderModel();
objModel.PartName = sdr["PartName"].ToString();
objModel.WorkorderNo = sdr["ReqNo"].ToString();
objModel.PartNo = sdr["PartNO"].ToString();
objModel.Type = sdr["Type"].ToString();
objModel.RfqID = sdr["RfqID"].ToString();
objModel.RawMaterial = sdr["ReqTypeMaterial"].ToString();
objList.Add(objModel);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <ssmtbl_WorkorderModel> GetWorkorderApprovalList(string dieStatus)
{
List <ssmtbl_WorkorderModel> objList = new List <ssmtbl_WorkorderModel>();
try
{
string sqlstr = "uspDieApproval";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "SelectDieList");
cmd.Parameters.AddWithValue("@Status", dieStatus.Trim());
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_WorkorderModel objModel = new ssmtbl_WorkorderModel();
objModel.DieNumber = sdr["DieNumber"].ToString();
objModel.WorkorderNo = sdr["WorkorderNumber"].ToString();
objModel.DieReqDate = Convert.ToDateTime(sdr["ReqDate"].ToString());
objModel.DieRequisitionID = Convert.ToInt32(sdr["DieRequisitionID"].ToString());
objList.Add(objModel);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <ssmtbl_WorkorderModel> GetWoDataByPOID(string poID)
{
List <ssmtbl_WorkorderModel> objWoList = new List <ssmtbl_WorkorderModel>();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_getInquiryfrompoid";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@POID", Convert.ToInt32(poID));
SqlDataReader sdr = cmd.ExecuteReader();
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataTable dt = new DataTable();
//da.Fill(dt);
while (sdr.Read())
{
ssmtbl_WorkorderModel objtemp = new ssmtbl_WorkorderModel();
objtemp.CutWeight = (sdr["cutweight"].ToString());
objtemp.HeatCode = (sdr["HeatCode"].ToString());
objtemp.ColorCode = (sdr["ColorCode"].ToString());
objtemp.RawMaterial = (sdr["RawMaterial"].ToString());
objtemp.Section = (sdr["Section"].ToString());
objtemp.PoRM = (sdr["PORM"].ToString());
objtemp.PoSection = (sdr["Section"].ToString());
objtemp.POSectionId = Convert.ToInt32(sdr["SectionId"].ToString());
objtemp.PoNo = (sdr["CustomerPONo"].ToString());
objtemp.CustomerName = (sdr["customerName"].ToString());
objtemp.CutWeight = (sdr["cutweight"].ToString());
objtemp.grossWeight = Convert.ToDecimal(sdr["grossweight"].ToString());
objtemp.DieNumber = (sdr["DieNumber"].ToString());
objtemp.FeasibilityHammerRequired = Convert.ToInt32(sdr["FeasibilityHammerRequired"].ToString());
objtemp.CutLength = Convert.ToDecimal(sdr["cutlength"].ToString());
objtemp.QtymentionedinPO = Convert.ToDouble(sdr["QtymentionedinPO"].ToString());
objtemp.NatureOfWork = Convert.ToInt32(sdr["FeasibilityNatureofWork"].ToString());
objtemp.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString());
objtemp.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString());
objtemp.PartName = sdr["PartName"].ToString();
objtemp.ConditionOfSupply = sdr["FeasibilityConditionSupply1"].ToString();
objtemp.HeatTreatment = (sdr["FeasibilityHeattreatment1"].ToString());
objtemp.HardnessMin = sdr["hardnessmin"].ToString();
objtemp.HardnessMax = sdr["hardnessmax"].ToString();
objtemp.HardnessUnit = sdr["hardnessunits"].ToString();
objtemp.HeatCode = sdr["HeatCode"].ToString();
objWoList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objWoList);
}
public ActionResult NewWorkorder()
{
ssmtbl_WorkorderModel objWoMod = new ssmtbl_WorkorderModel();
objWoMod.WorkorderNo = objWoData.GetMaxWorkorderNo();
//ViewData["PoNo"] = objDrop.FrqRepOrder();
objWoMod.DateOfIssue = DateTime.Now;
objWoMod.TargetDate = DateTime.Now;
objWoMod.ProductionStartDate = DateTime.Now;
return(View(objWoMod));
}
public string InsertWorkorder(ssmtbl_WorkorderModel objWoMod)
{
string result = "Error Creating Workorder";
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_Insert_Workorder";
SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
var wono = objWoMod.WorkorderNo;
var pono = objWoMod.PoNo;
wono = ("WO-" + pono + "-" + ((Convert.ToInt64(wono.Split('-')[1])).ToString("00000")));
cmd.Parameters.AddWithValue("@WorkorderNo", wono);
// cmd.Parameters.AddWithValue("@RawMaterial", objWoMod.RawMaterial);
cmd.Parameters.AddWithValue("@HeatCode", objWoMod.HeatCode);
//cmd.Parameters.AddWithValue("@Section", objWoMod.PoSection);
//cmd.Parameters.AddWithValue("@DateOfIssue", objWoMod.DateOfIssue);
cmd.Parameters.AddWithValue("@TargetDate", objWoMod.TargetDate);
cmd.Parameters.AddWithValue("@CutWeight", objWoMod.CutWeight);
cmd.Parameters.AddWithValue("@ColorCode", objWoMod.ColorCode);
cmd.Parameters.AddWithValue("@PoNo", objWoMod.PoNo);
cmd.Parameters.AddWithValue("@Status", "601");
cmd.Parameters.AddWithValue("@CustomerName", objWoMod.CustomerName);
cmd.Parameters.AddWithValue("@AllocatedRM", objWoMod.AllocatedRM);
cmd.Parameters.AddWithValue("@AllocatedSection", objWoMod.AllocatedSection);
cmd.Parameters.AddWithValue("@PoRM", objWoMod.PoRM);
cmd.Parameters.AddWithValue("@PoSection", objWoMod.PoSection);
cmd.ExecuteNonQuery();
connection.Close();
result = "Workorder Created Successfully!";
}
catch (Exception ex)
{
Global.ErrorHandlerClass.LogError(ex);
}
return(result);
}