public ActionResult Delete(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
//start Logging
int UserID = Convert.ToInt32(Session["UserId"]);
String Username = Session["Username"].ToString();
//string CompleteModificationdetail = "Deleted MachineDetails";
//Action = "Delete";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
tblmasterparts_st_sw tblmp = db.tblmasterparts_st_sw.Find(id);
tblmp.IsDeleted = 1;
tblmp.ModifiedBy = UserID;
tblmp.ModifiedOn = DateTime.Now;
db.Entry(tblmp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public string DeleteDet(int id)
{
string ret = "";
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
//start Logging
int UserID = Convert.ToInt32(Session["UserId"]);
String Username = Session["Username"].ToString();
//string CompleteModificationdetail = "Deleted MachineDetails";
//Action = "Delete";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
tblmasterparts_st_sw tblmp = db.tblmasterparts_st_sw.Find(id);
tblmp.IsDeleted = 1;
tblmp.ModifiedBy = UserID;
tblmp.ModifiedOn = DateTime.Now;
db.Entry(tblmp).State = EntityState.Modified;
db.SaveChanges();
ret = "Success";
return(ret);
}
public ActionResult Edit(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
tblmasterparts_st_sw masterpartsData = db.tblmasterparts_st_sw.Where(m => m.PARTSSTSWID == id).FirstOrDefault();
return(View(masterpartsData));
}
public tblmasterparts_st_sw Gettblmasterparts_st_swDet3(string opNo, string partNo)
{
tblmasterparts_st_sw ddldet = new tblmasterparts_st_sw();
Repository <tblmasterparts_st_sw> lista = new Repository <tblmasterparts_st_sw>();
try
{
string query = "SELECT * from [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].tblmasterparts_st_sw WHERE IsDeleted = 0 and OpNo ='" + opNo + "' and PartNo ='" + partNo + "'";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(ddldet);
}
public tblmasterparts_st_sw Gettblmasterparts_st_swDet(string OperationNoString, string PartNoString)
{
tblmasterparts_st_sw ddldet = new tblmasterparts_st_sw();
Repository <tblmasterparts_st_sw> lista = new Repository <tblmasterparts_st_sw>();
try
{
string query = "SELECT StdCuttingTimeUnit from [i_facility_TSAL].[dbo].tblmasterparts_st_sw WHERE OpNo ='" + OperationNoString + "' and PartNo ='" + PartNoString + "'";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(ddldet);
}
public string Gettblmasterparts_st_swDet(string OperationNoString, string PartNoString)
{
string det = "";
tblmasterparts_st_sw ddldet = new tblmasterparts_st_sw();
Repository <tblmasterparts_st_sw> lista = new Repository <tblmasterparts_st_sw>();
try
{
string query = "SELECT StdCuttingTimeUnit from [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].tblmasterparts_st_sw WHERE OpNo ='" + OperationNoString + "' and PartNo ='" + PartNoString + "'";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
det = ddldet.StdCuttingTimeUnit;
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(det);
}
public decimal Gettblmasterparts_st_swDet1(string opNo, string partNo)
{
decimal det = 0;
tblmasterparts_st_sw ddldet = new tblmasterparts_st_sw();
Repository <tblmasterparts_st_sw> lista = new Repository <tblmasterparts_st_sw>();
try
{
string query = "SELECT StdCuttingTime from [i_facility_taml].[dbo].tblmasterparts_st_sw WHERE IsDeleted = 0 and OpNo ='" + opNo + "' and PartNo ='" + partNo + "'";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
det = (decimal)ddldet.StdCuttingTime;
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(det);
}
public ActionResult Edit(tblmasterparts_st_sw tblmp)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
//ActiveLog Code
int UserID = Convert.ToInt32(Session["UserId"]);
//string CompleteModificationdetail = "New Creation";
//Action = "Create";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
string partno = tblmp.PartNo;
string opno = tblmp.OpNo;
int mpid = tblmp.PARTSSTSWID;
var partInMP = db.tblmasterparts_st_sw.Where(m => m.IsDeleted == 0 && (m.PartNo == partno && m.OpNo == opno) && m.PARTSSTSWID != mpid).ToList();
if (partInMP.Count > 0)
{
Session["Error"] = "PartNo " + partno + " has details in Database";
return(View(tblmp));
}
tblmp.CreatedOn = DateTime.Now;
tblmp.CreatedBy = UserID;
tblmp.IsDeleted = 0;
db.Entry(tblmp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public string EditDetails(tblmasterparts_st_sw tblmp)
{
string ret = "";
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
//ActiveLog Code
int UserID = Convert.ToInt32(Session["UserId"]);
//string CompleteModificationdetail = "New Creation";
//Action = "Create";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
string partno = tblmp.PartNo;
string opno = tblmp.OpNo;
int mpid = tblmp.PARTSSTSWID;
var partInMP = db.tblmasterparts_st_sw.Where(m => m.IsDeleted == 0 && (m.PartNo == partno && m.OpNo == opno) && m.PARTSSTSWID != mpid).ToList();
if (partInMP.Count > 0)
{
Session["Error"] = "PartNo " + partno + " has details in Database";
//return View(tblmp);
}
tblmp.CreatedOn = DateTime.Now;
tblmp.CreatedBy = UserID;
tblmp.IsDeleted = 0;
db.Entry(tblmp).State = EntityState.Modified;
db.SaveChanges();
ret = "Success";
return(ret);
}
//public ActionResult ImportMasterPartsstsw(HttpPostedFileBase file,string UploadType)
public ActionResult ImportMasterPartsstsw(HttpPostedFileBase file, string UploadType)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
//Deleting Excel file
#region
string fileLocation1 = Server.MapPath("~/Content/");
DirectoryInfo di = new DirectoryInfo(fileLocation1);
FileInfo[] files = di.GetFiles("*.xlsx").Where(p => p.Extension == ".xlsx").ToArray();
foreach (FileInfo file1 in files)
{
try
{
file1.Attributes = FileAttributes.Normal;
System.IO.File.Delete(file1.FullName);
}
catch { }
}
#endregion
DataSet ds = new DataSet();
if (Request.Files["file"].ContentLength > 0)
{
string fileExtension = System.IO.Path.GetExtension(Request.Files["file"].FileName);
if (fileExtension == ".xls" || fileExtension == ".xlsx")
{
string fileLocation = Server.MapPath("~/Content/") + Request.Files["file"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["file"].SaveAs(fileLocation);
string excelConnectionString = string.Empty;
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
//connection String for xls file format.
if (fileExtension == ".xls")
{
excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
//connection String for xlsx file format.
else if (fileExtension == ".xlsx")
{
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
//Create Connection to Excel work book and add oledb namespace
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
excelConnection.Open();
DataTable dt = new DataTable();
dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt == null)
{
return(null);
}
String[] excelSheets = new String[dt.Rows.Count];
int t = 0;
//excel data saves in temp file here.
foreach (DataRow row in dt.Rows)
{
excelSheets[t] = row["TABLE_NAME"].ToString();
t++;
}
OleDbConnection excelConnection1 = new OleDbConnection(excelConnectionString);
string query = string.Format("Select * from [{0}]", excelSheets[0]);
using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, excelConnection1))
{
dataAdapter.Fill(ds);
}
excelConnection.Close();
excelConnection1.Close();
}
if (fileExtension.ToString().ToLower().Equals(".xml"))
{
string fileLocation = Server.MapPath("~/Content/") + Request.Files["FileUpload"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["FileUpload"].SaveAs(fileLocation);
XmlTextReader xmlreader = new XmlTextReader(fileLocation);
// DataSet ds = new DataSet();
ds.ReadXml(xmlreader);
xmlreader.Close();
}
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
List <string> TimeUnits = new List <string>();
TimeUnits.Add("Min");
TimeUnits.Add("Hrs");
TimeUnits.Add("Sec");
List <string> WeightUnits = new List <string>();
WeightUnits.Add("Kg");
WeightUnits.Add("g");
string ErrorMsg = null;
if (UploadType == "OverWrite") // Accept only New Codes
{
#region
for (int i = 1; i < ds.Tables[0].Rows.Count; i++)
{
tblmasterparts_st_sw tblmp = new tblmasterparts_st_sw();
String Username = Session["Username"].ToString();
tblmp.CreatedBy = Convert.ToInt32(Session["UserId"]);
tblmp.CreatedOn = DateTime.Now;
tblmp.IsDeleted = 0;
string PartName = null, OpNo = null;
PartName = Convert.ToString(ds.Tables[0].Rows[i][0]);
OpNo = Convert.ToString(ds.Tables[0].Rows[i][1]);
using (Tata.Models.mazakdaqEntities db1 = new Tata.Models.mazakdaqEntities())
{
var MasterStdPWTData = db1.tblmasterparts_st_sw.Where(m => m.PartNo == PartName && m.OpNo == OpNo).FirstOrDefault();
if (MasterStdPWTData != null)
{
ErrorMsg = ErrorMsg + PartName + " and " + OpNo + " has details in Database.\n";
continue;
}
else if (string.IsNullOrEmpty(PartName) || string.IsNullOrEmpty(OpNo))
{
ErrorMsg += " PartName or OpNo cannot be empty for " + PartName + " and " + OpNo + " .\n";
continue;
}
else
{
tblmp.PartNo = PartName;
tblmp.OpNo = OpNo;
}
}
try
{
tblmp.StdSetupTime = Convert.ToDecimal(ds.Tables[0].Rows[i][2]);
string setupUnit = Convert.ToString(ds.Tables[0].Rows[i][3]);
if (TimeUnits.Contains(setupUnit))
{
tblmp.StdSetupTimeUnit = setupUnit;
}
else //Default Unit
{
tblmp.StdSetupTimeUnit = "Min";
}
}
catch
{
ErrorMsg = ErrorMsg + "StdSetupTime of Part Number" + PartName + " should be Number.\n";
continue;
}
decimal stdCuttingTime = 0;
try
{
stdCuttingTime = Convert.ToDecimal(ds.Tables[0].Rows[i][4]);
}
catch
{
ErrorMsg = ErrorMsg + "StdCuttingTime of " + PartName + " should be Numbers.\n";
continue;
}
//if (stdCuttingTime == 0)
//{
// ErrorMsg = ErrorMsg + "StdCuttingTime of " + PartName + " cannot be Zero.\n";
// continue;
//}
//else
{
tblmp.StdCuttingTime = stdCuttingTime;
string CuttingTimeUnit = Convert.ToString(ds.Tables[0].Rows[i][5]);
if (TimeUnits.Contains(CuttingTimeUnit))
{
tblmp.StdCuttingTimeUnit = CuttingTimeUnit;
}
else //Default Unit
{
tblmp.StdCuttingTimeUnit = "Min";
}
}
try
{
tblmp.StdChangeoverTime = Convert.ToDecimal(ds.Tables[0].Rows[i][6]);
string ChangeoverUnit = Convert.ToString(ds.Tables[0].Rows[i][7]);
if (TimeUnits.Contains(ChangeoverUnit))
{
tblmp.StdChangeoverTimeUnit = ChangeoverUnit;
}
else //Default Unit
{
tblmp.StdChangeoverTimeUnit = "Min";
}
}
catch
{
ErrorMsg = ErrorMsg + "StdChangeoverTime of Part Number" + PartName + " should be Number.\n";
continue;
}
try
{
tblmp.InputWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][8]);
string InputWeightUnit = Convert.ToString(ds.Tables[0].Rows[i][9]);
if (WeightUnits.Contains(InputWeightUnit))
{
tblmp.InputWeightUnit = InputWeightUnit;
}
else //Default Unit
{
tblmp.InputWeightUnit = "Kg";
}
tblmp.OutputWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][10]);
string OutputWeightUnit = Convert.ToString(ds.Tables[0].Rows[i][11]);
if (WeightUnits.Contains(OutputWeightUnit))
{
tblmp.OutputWeightUnit = OutputWeightUnit;
}
else //Default Unit
{
tblmp.OutputWeightUnit = "Kg";
}
tblmp.MaterialRemovedQty = Convert.ToDecimal(ds.Tables[0].Rows[i][12]);
string MaterialRemovedQtyUnit = Convert.ToString(ds.Tables[0].Rows[i][13]);
if (WeightUnits.Contains(MaterialRemovedQtyUnit))
{
tblmp.MaterialRemovedQtyUnit = MaterialRemovedQtyUnit;
}
else //Default Unit
{
tblmp.MaterialRemovedQtyUnit = "Kg";
}
}
catch
{
ErrorMsg = ErrorMsg + "I/O Weights & Materials Removed of " + PartName + " should be Numbers.\n";
continue;
}
db.tblmasterparts_st_sw.Add(tblmp);
db.SaveChanges();
}
#endregion
}
else if (UploadType == "New") // Delete Duplicate and Insert New. // if not Duplicate insert that
{
#region
for (int i = 1; i < ds.Tables[0].Rows.Count; i++)
{
tblmasterparts_st_sw tblmp = new tblmasterparts_st_sw();
String Username = Session["Username"].ToString();
tblmp.CreatedBy = Convert.ToInt32(Session["UserId"]);
tblmp.CreatedOn = DateTime.Now;
tblmp.IsDeleted = 0;
string PartName = null, OpNo = null;
PartName = Convert.ToString(ds.Tables[0].Rows[i][0]);
OpNo = Convert.ToString(ds.Tables[0].Rows[i][1]);
using (Tata.Models.mazakdaqEntities db1 = new Tata.Models.mazakdaqEntities())
{
//var MasterStdPWTData = db1.tblmasterparts_st_sw.Where(m => m.PartNo == PartName && m.OpNo == OpNo).FirstOrDefault();
//if (MasterStdPWTData != null)
//{
// ErrorMsg += PartName + " and " + OpNo + " has details in Database.\n";
// continue;
//}
//else
if (string.IsNullOrEmpty(PartName) || string.IsNullOrEmpty(OpNo))
{
ErrorMsg += "PartNo and OperationNo cannot be null .\n";
continue;
}
else
{
tblmp.PartNo = PartName;
tblmp.OpNo = OpNo;
}
}
try
{
tblmp.StdSetupTime = Convert.ToDecimal(ds.Tables[0].Rows[i][2]);
string setupUnit = Convert.ToString(ds.Tables[0].Rows[i][3]);
if (TimeUnits.Contains(setupUnit))
{
tblmp.StdSetupTimeUnit = setupUnit;
}
else //Default Unit
{
tblmp.StdSetupTimeUnit = "Min";
}
}
catch
{
ErrorMsg = ErrorMsg + "StdSetupTime of Part Number" + PartName + " should be Number.\n";
continue;
}
decimal stdCuttingTime = 0;
try
{
stdCuttingTime = Convert.ToDecimal(ds.Tables[0].Rows[i][4]);
}
catch
{
ErrorMsg = ErrorMsg + "StdCuttingTime of " + PartName + " should be Numbers.\n";
continue;
}
//if (stdCuttingTime == 0)
//{
// ErrorMsg = ErrorMsg + "StdCuttingTime of " + PartName + " cannot be Zero.\n";
// continue;
//}
//else
{
tblmp.StdCuttingTime = stdCuttingTime;
string CuttingTimeUnit = Convert.ToString(ds.Tables[0].Rows[i][5]);
if (TimeUnits.Contains(CuttingTimeUnit))
{
tblmp.StdCuttingTimeUnit = CuttingTimeUnit;
}
else //Default Unit
{
tblmp.StdCuttingTimeUnit = "Min";
}
}
try
{
tblmp.StdChangeoverTime = Convert.ToDecimal(ds.Tables[0].Rows[i][6]);
string ChangeoverUnit = Convert.ToString(ds.Tables[0].Rows[i][7]);
if (TimeUnits.Contains(ChangeoverUnit))
{
tblmp.StdChangeoverTimeUnit = ChangeoverUnit;
}
else //Default Unit
{
tblmp.StdChangeoverTimeUnit = "Min";
}
}
catch
{
ErrorMsg = ErrorMsg + "StdChangeoverTime of Part Number" + PartName + " should be Number.\n";
continue;
}
try
{
tblmp.InputWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][8]);
string InputWeightUnit = Convert.ToString(ds.Tables[0].Rows[i][9]);
if (WeightUnits.Contains(InputWeightUnit))
{
tblmp.InputWeightUnit = InputWeightUnit;
}
else //Default Unit
{
tblmp.InputWeightUnit = "Kg";
}
tblmp.OutputWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][10]);
string OutputWeightUnit = Convert.ToString(ds.Tables[0].Rows[i][11]);
if (WeightUnits.Contains(OutputWeightUnit))
{
tblmp.OutputWeightUnit = OutputWeightUnit;
}
else //Default Unit
{
tblmp.OutputWeightUnit = "Kg";
}
tblmp.MaterialRemovedQty = Convert.ToDecimal(ds.Tables[0].Rows[i][12]);
string MaterialRemovedQtyUnit = Convert.ToString(ds.Tables[0].Rows[i][13]);
if (WeightUnits.Contains(MaterialRemovedQtyUnit))
{
tblmp.MaterialRemovedQtyUnit = MaterialRemovedQtyUnit;
}
else //Default Unit
{
tblmp.MaterialRemovedQtyUnit = "Kg";
}
}
catch
{
ErrorMsg = ErrorMsg + "I/O Weights & Materials Removed of " + PartName + " should be Numbers.\n";
continue;
}
//check for dup and delete previous one.
var Dupdata = db.tblmasterparts_st_sw.Where(m => m.PartNo == PartName && m.OpNo == OpNo && m.IsDeleted == 0).FirstOrDefault();
if (Dupdata != null)
{
Dupdata.IsDeleted = 1;
Dupdata.DeletedDate = DateTime.Now;
db.Entry(Dupdata).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
db.tblmasterparts_st_sw.Add(tblmp);
db.SaveChanges();
}
#endregion
}
else if (UploadType == "Update") // OverWrite Existing Values
{
#region
for (int i = 1; i < ds.Tables[0].Rows.Count; i++)
{
tblmasterparts_st_sw tblmp = new tblmasterparts_st_sw();
String Username = Session["Username"].ToString();
tblmp.CreatedBy = Convert.ToInt32(Session["UserId"]);
tblmp.CreatedOn = DateTime.Now;
tblmp.IsDeleted = 0;
string PartName = null, OpNo = null;
PartName = Convert.ToString(ds.Tables[0].Rows[i][0]);
OpNo = Convert.ToString(ds.Tables[0].Rows[i][1]);
DateTime createdOn = DateTime.Now;
//using (Tata.Models.mazakdaqEntities db1 = new Tata.Models.mazakdaqEntities())
//{
//var MasterStdPWTData = db1.tblmasterparts_st_sw.Where(m => m.PartNo == PartName && m.OpNo == OpNo).FirstOrDefault();
//if (MasterStdPWTData != null)
//{
// ErrorMsg = ErrorMsg + PartName + " and " + OpNo + " has details in Database.\n";
// continue;
//}
//else
if (string.IsNullOrEmpty(PartName) || string.IsNullOrEmpty(OpNo))
{
ErrorMsg = ErrorMsg + PartName + " and " + OpNo + " has details in Database.\n";
continue;
}
else
{
tblmp.PartNo = PartName;
tblmp.OpNo = OpNo;
}
//}
try
{
tblmp.StdSetupTime = Convert.ToDecimal(ds.Tables[0].Rows[i][2]);
string setupUnit = Convert.ToString(ds.Tables[0].Rows[i][3]);
if (TimeUnits.Contains(setupUnit))
{
tblmp.StdSetupTimeUnit = setupUnit;
}
else //Default Unit
{
tblmp.StdSetupTimeUnit = "Min";
}
}
catch
{
ErrorMsg = ErrorMsg + "StdSetupTime of Part Number" + PartName + " should be Number.\n";
continue;
}
decimal stdCuttingTime = 0;
try
{
stdCuttingTime = Convert.ToDecimal(ds.Tables[0].Rows[i][4]);
}
catch
{
ErrorMsg = ErrorMsg + "StdCuttingTime of " + PartName + " should be Numbers.\n";
continue;
}
//if (stdCuttingTime == 0)
//{
// ErrorMsg = ErrorMsg + "StdCuttingTime of " + PartName + " cannot be Zero.\n";
// continue;
//}
//else
{
tblmp.StdCuttingTime = stdCuttingTime;
string CuttingTimeUnit = Convert.ToString(ds.Tables[0].Rows[i][5]);
if (TimeUnits.Contains(CuttingTimeUnit))
{
tblmp.StdCuttingTimeUnit = CuttingTimeUnit;
}
else //Default Unit
{
tblmp.StdCuttingTimeUnit = "Min";
}
}
try
{
tblmp.StdChangeoverTime = Convert.ToDecimal(ds.Tables[0].Rows[i][6]);
string ChangeoverUnit = Convert.ToString(ds.Tables[0].Rows[i][7]);
if (TimeUnits.Contains(ChangeoverUnit))
{
tblmp.StdChangeoverTimeUnit = ChangeoverUnit;
}
else //Default Unit
{
tblmp.StdChangeoverTimeUnit = "Min";
}
}
catch
{
ErrorMsg = ErrorMsg + "StdChangeoverTime of Part Number" + PartName + " should be Number.\n";
continue;
}
try
{
tblmp.InputWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][8]);
string InputWeightUnit = Convert.ToString(ds.Tables[0].Rows[i][9]);
if (WeightUnits.Contains(InputWeightUnit))
{
tblmp.InputWeightUnit = InputWeightUnit;
}
else //Default Unit
{
tblmp.InputWeightUnit = "Kg";
}
tblmp.OutputWeight = Convert.ToDecimal(ds.Tables[0].Rows[i][10]);
string OutputWeightUnit = Convert.ToString(ds.Tables[0].Rows[i][11]);
if (WeightUnits.Contains(OutputWeightUnit))
{
tblmp.OutputWeightUnit = OutputWeightUnit;
}
else //Default Unit
{
tblmp.OutputWeightUnit = "Kg";
}
tblmp.MaterialRemovedQty = Convert.ToDecimal(ds.Tables[0].Rows[i][12]);
string MaterialRemovedQtyUnit = Convert.ToString(ds.Tables[0].Rows[i][13]);
if (WeightUnits.Contains(MaterialRemovedQtyUnit))
{
tblmp.MaterialRemovedQtyUnit = MaterialRemovedQtyUnit;
}
else //Default Unit
{
tblmp.MaterialRemovedQtyUnit = "Kg";
}
}
catch
{
ErrorMsg = ErrorMsg + "I/O Weights & Materials Removed of " + PartName + " should be Numbers.\n";
continue;
}
var MasterStdPWTData = db.tblmasterparts_st_sw.Where(m => m.PartNo == PartName && m.OpNo == OpNo && m.IsDeleted == 0).FirstOrDefault();
if (MasterStdPWTData == null)
{
db.tblmasterparts_st_sw.Add(tblmp);
db.SaveChanges();
}
else
{
MasterStdPWTData.InputWeight = tblmp.InputWeight;
MasterStdPWTData.InputWeightUnit = tblmp.InputWeightUnit;
MasterStdPWTData.MaterialRemovedQty = tblmp.MaterialRemovedQty;
MasterStdPWTData.MaterialRemovedQtyUnit = tblmp.MaterialRemovedQtyUnit;
MasterStdPWTData.ModifiedBy = Convert.ToInt32(Session["UserId"]);
MasterStdPWTData.ModifiedOn = DateTime.Now;
MasterStdPWTData.OpNo = tblmp.OpNo;
MasterStdPWTData.OutputWeight = tblmp.OutputWeight;
MasterStdPWTData.OutputWeightUnit = tblmp.OutputWeightUnit;
MasterStdPWTData.PartNo = tblmp.PartNo;
MasterStdPWTData.StdChangeoverTime = tblmp.StdChangeoverTime;
MasterStdPWTData.StdChangeoverTimeUnit = tblmp.StdChangeoverTimeUnit;
MasterStdPWTData.StdCuttingTime = tblmp.StdCuttingTime;
MasterStdPWTData.StdCuttingTimeUnit = tblmp.StdCuttingTimeUnit;
MasterStdPWTData.StdSetupTime = tblmp.StdSetupTime;
MasterStdPWTData.StdSetupTimeUnit = tblmp.StdSetupTimeUnit;
db.Entry(MasterStdPWTData).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
#endregion
}
Session["PartNo"] = ErrorMsg;
}
//return RedirectToAction("Index", "MasterParts");
return(View());
}
