public CommonResponse AddUpdateChildFgPartNo(addChildfgPartNoDet data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblchildfgpartno.Where(m => m.ChildFgpartId == data.childFgpartId && m.IsDeleted == 0).FirstOrDefault();
if (check == null)
{
UnitworkccsTblchildfgpartno UnitworkccsTblchildfgpartnodet = new UnitworkccsTblchildfgpartno();
UnitworkccsTblchildfgpartnodet.ChildFgpartId = data.childFgpartId;
UnitworkccsTblchildfgpartnodet.ChildFgPartNo = data.fgPartNo;
UnitworkccsTblchildfgpartnodet.FgPartNo = data.fgPartNo;
UnitworkccsTblchildfgpartnodet.ChildPartNoDesc = data.childPartNoDesc;
UnitworkccsTblchildfgpartnodet.FgPartDesc = db.UnitworkccsTblfgandcellallocation.Where(m => m.PartNo == data.fgPartNo).Select(m => m.PartName).FirstOrDefault();
UnitworkccsTblchildfgpartnodet.IsDeleted = 0;
UnitworkccsTblchildfgpartnodet.CreatedBy = 1;
UnitworkccsTblchildfgpartnodet.CreatedOn = DateTime.Now;
db.UnitworkccsTblchildfgpartno.Add(UnitworkccsTblchildfgpartnodet);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
//check.ChildFgpartId = data.ChildFgpartId;
check.ChildFgPartNo = data.childFgPartNo;
check.FgPartNo = data.fgPartNo;
check.FgPartDesc = db.UnitworkccsTblfgandcellallocation.Where(m => m.PartNo == data.fgPartNo).Select(m => m.PartName).FirstOrDefault();
check.ChildPartNoDesc = data.childPartNoDesc;
check.ModifiedBy = 2;
check.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Redirect The Page
/// </summary>
/// <param name="HostName"></param>
/// <param name="IpAddress"></param>
/// <returns></returns>
public CommonResponse AddAndEditToolAndSocketDetails(TblToolAndSocketDetailsCustom data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTbltoolandsocketdetails.Where(m => m.MachineId == data.machineId && m.SocketNo == data.socketNo && m.IsDeleted == 0).FirstOrDefault();
if (check == null)
{
var item = db2.TblIssuedReceived.Where(m => m.BarCodeNo == data.toolNumber && m.MachineId == data.machineId).FirstOrDefault();
if (item != null)
{
var toolDetails = db2.TblTools.Where(m => m.ToolName.Trim().Contains(item.ToolName.Trim())).FirstOrDefault();
if (toolDetails != null)
{
int stdToolLife = Convert.ToInt32(toolDetails.StandardToolLife);
UnitworkccsTbltoolandsocketdetails tblToolAndSocket = new UnitworkccsTbltoolandsocketdetails();
tblToolAndSocket.Qrcode = data.toolNumber;
tblToolAndSocket.ToolNumber = item.ToolName.Trim();
tblToolAndSocket.SocketNo = data.socketNo;
tblToolAndSocket.MachineId = data.machineId;
tblToolAndSocket.StandardToolLife = stdToolLife;
tblToolAndSocket.ActaulToolLife = 0;
tblToolAndSocket.ToolInsertedDateTime = DateTime.Now;
tblToolAndSocket.CreatedOn = DateTime.Now;
tblToolAndSocket.CreatedBy = 1;
tblToolAndSocket.IsDeleted = 0;
db.Add(tblToolAndSocket);
db.SaveChanges();
}
}
obj.isStatus = true;
obj.response = Resource.ResourceResponse.AddedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Add Update List Of Stoppage
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddUpdateListOfStoppage(List <AddAndEditStoppage> data)
{
CommonResponse obj = new CommonResponse();
try
{
foreach (var item in data)
{
var check = db.UnitworkccsTblstoppage.Where(m => m.StoppagesId == item.stoppageId && m.AlramNo == item.alarmNo).FirstOrDefault();
if (check == null)
{
UnitworkccsTblstoppage tblStoppage = new UnitworkccsTblstoppage();
tblStoppage.CategoryId = item.categoryId;
tblStoppage.AlramNo = item.alarmNo;
tblStoppage.AlramDesc = item.alarmDesc;
tblStoppage.SourceId = item.sourceId;
tblStoppage.IsDeleted = 0;
tblStoppage.CreatedOn = DateTime.Now;
db.UnitworkccsTblstoppage.Add(tblStoppage);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
check.CategoryId = item.categoryId;
check.AlramNo = item.alarmNo;
check.AlramDesc = item.alarmDesc;
check.SourceId = item.sourceId;
check.IsDeleted = 0;
check.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
}
catch (Exception e)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// AddUpdateVendorDetails
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddUpdateVendorDetails(VendorEntity data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblvendor.Where(m => m.VendorId == data.vendorId && m.IsDeleted == 0).FirstOrDefault();
if (check == null)
{
UnitworkccsTblvendor UnitworkccsTblvendordet = new UnitworkccsTblvendor();
UnitworkccsTblvendordet.Vendor = data.vendor;
UnitworkccsTblvendordet.VendorName = data.vendorName;
UnitworkccsTblvendordet.IsDeleted = 0;
UnitworkccsTblvendordet.CreatedOn = DateTime.Now;
UnitworkccsTblvendordet.CreatedBy = 1;
db.UnitworkccsTblvendor.Add(UnitworkccsTblvendordet);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
check.Vendor = data.vendor;
check.VendorName = data.vendorName;
check.ModifiedBy = 2;
check.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// AddUpdateToolNameMaster
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddUpdateToolNameMaster(ToolNameMasterEntity data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsToolnamemaster.Where(m => m.ToolId == data.toolId && m.IsDeleted == 0).FirstOrDefault();
if (check == null)
{
UnitworkccsToolnamemaster unitworkccsToolNameMasterDet = new UnitworkccsToolnamemaster();
unitworkccsToolNameMasterDet.ToolName = data.toolName;
unitworkccsToolNameMasterDet.ToolDesc = data.toolDesc;
unitworkccsToolNameMasterDet.IsDeleted = 0;
unitworkccsToolNameMasterDet.CreatedOn = DateTime.Now;
db.UnitworkccsToolnamemaster.Add(unitworkccsToolNameMasterDet);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
check.ToolName = data.toolName;
check.ToolDesc = data.toolDesc;
check.ModifiedOn = DateTime.Now;
check.ModifiedBy = 2;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Add Update Product Wise Defect Code
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddUpdateProductWiseDefectCode(List <AddEditProuctWiseDefectCodes> data)
{
CommonResponse obj = new CommonResponse();
try
{
foreach (var item in data)
{
var check = db.UnitworkccsTblproductwisedefectcodes.Where(m => m.ProductWiseDefectCodeId == item.productWiseDefectCodeId && m.Trim == item.trim).FirstOrDefault();
if (check == null)
{
UnitworkccsTblproductwisedefectcodes UnitworkccsTblproductwisedefectcodes = new UnitworkccsTblproductwisedefectcodes();
UnitworkccsTblproductwisedefectcodes.PlantId = item.plantId;
UnitworkccsTblproductwisedefectcodes.PartNo = item.partNo;
UnitworkccsTblproductwisedefectcodes.PartName = item.partName;
UnitworkccsTblproductwisedefectcodes.Trim = item.trim;
UnitworkccsTblproductwisedefectcodes.DefectCodeId = item.defectCodeId;
UnitworkccsTblproductwisedefectcodes.IsDeleted = 0;
UnitworkccsTblproductwisedefectcodes.CreatedOn = DateTime.Now;
db.UnitworkccsTblproductwisedefectcodes.Add(UnitworkccsTblproductwisedefectcodes);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
check.PlantId = item.plantId;
check.PartNo = item.partNo;
check.PartName = item.partName;
check.Trim = item.trim;
check.DefectCodeId = item.defectCodeId;
check.IsDeleted = 0;
check.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
}
catch (Exception e)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Upload Child Fg Part No
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse UploadChildFgPartNo(List <UploadChildPartNo> data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblchildfgpartno.Where(m => m.IsDeleted == 0).ToList();
db.RemoveRange(check);
db.SaveChanges();
foreach (var item in data)
{
UnitworkccsTblchildfgpartno UnitworkccsTblchildfgpartno = new UnitworkccsTblchildfgpartno();
UnitworkccsTblchildfgpartno.ChildFgPartNo = item.childFgPartNo;
UnitworkccsTblchildfgpartno.ChildPartNoDesc = item.childPartNoDesc;
UnitworkccsTblchildfgpartno.FgPartNo = item.fgPartNo;
UnitworkccsTblchildfgpartno.FgPartDesc = item.fgPartDesc;
UnitworkccsTblchildfgpartno.IsDeleted = 0;
UnitworkccsTblchildfgpartno.CreatedOn = DateTime.Now;
db.UnitworkccsTblchildfgpartno.Add(UnitworkccsTblchildfgpartno);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Add Dry Run
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponseWithIds AddDryRun(DryRunDetails data)
{
CommonResponseWithIds obj = new CommonResponseWithIds();
try
{
CommonFunction commonFunction = new CommonFunction();
string shift = commonFunction.GetCurrentShift();
string correctedDate = commonFunction.GetCorrectedDate();
var roleId = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == data.userId).Select(m => m.RoleId).FirstOrDefault();
var check = db.UnitworkccsTbldryrun.Where(m => m.MachineId == data.machineId && m.FgPartId == data.fgPartId && m.EndDate == null && roleId == 11).FirstOrDefault();
if (check == null)
{
UnitworkccsTbldryrun UnitworkccsTbldryrun = new UnitworkccsTbldryrun();
UnitworkccsTbldryrun.FgPartId = data.fgPartId;
UnitworkccsTbldryrun.MachineId = data.machineId;
UnitworkccsTbldryrun.StartDate = DateTime.Now;
UnitworkccsTbldryrun.CreatedOn = DateTime.Now;
UnitworkccsTbldryrun.CorrectedDate = correctedDate;
UnitworkccsTbldryrun.IsDeleted = 0;
UnitworkccsTbldryrun.Shift = shift;
db.UnitworkccsTbldryrun.Add(UnitworkccsTbldryrun);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
obj.id = UnitworkccsTbldryrun.DryRunId;
}
}
catch (Exception)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
public CommonResponse AddUpdateEmployeeShift(AddUpdateOperatorShift data)
{
CommonResponse obj = new CommonResponse();
try
{
DateTime fdate = Convert.ToDateTime(data.fromDate).Date;
DateTime tdate = Convert.ToDateTime(data.toDate).Date;
var check = db.UnitworkccsTblemployeeshiftdetails.Where(m => m.Id == data.id && m.EmployeeId == data.employeeId && (m.FromDate.Date <= fdate && m.ToDate.Date >= tdate)).FirstOrDefault();
if (check == null)
{
UnitworkccsTblemployeeshiftdetails tblOperatorDetailsShift = new UnitworkccsTblemployeeshiftdetails();
tblOperatorDetailsShift.EmployeeId = Convert.ToInt32(db.UnitworkccsTbloperatordetails.Where(m => m.OpId == data.employeeId).Select(m => m.OpNo).FirstOrDefault());
tblOperatorDetailsShift.Shift = data.shift;
tblOperatorDetailsShift.MachineIds = data.machineIds;
tblOperatorDetailsShift.FromDate = fdate;
tblOperatorDetailsShift.ToDate = tdate;
tblOperatorDetailsShift.IsDeleted = 0;
tblOperatorDetailsShift.CreatedOn = DateTime.Now;
tblOperatorDetailsShift.CreatedBy = 1;
db.UnitworkccsTblemployeeshiftdetails.Add(tblOperatorDetailsShift);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
check.Shift = data.shift;
check.MachineIds = data.machineIds;
// check.FromDate = fdate;
// check.ToDate = tdate;
check.IsDeleted = 0;
check.ModifiedOn = DateTime.Now;
check.ModifiedBy = 2;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
catch (Exception e)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Add And Edit Document Uploader
/// </summary>
/// <param name="documentDetails"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponseWithIdsDoc AddAndEditDocumentUploader(DocumentUplodedMasterCustom documentDetails)
{
CommonResponseWithIdsDoc response = new CommonResponseWithIdsDoc();
string fileName = "";
if (documentDetails.Image != null)
{
try
{
string extensionFile = documentDetails.Image.FileName;
string[] fileArray = extensionFile.Split('.');
try
{
extensionFile = fileArray[1];
}
catch
{
extensionFile = "jpeg";
}
fileName = Guid.NewGuid().ToString() + "." + extensionFile;
#region save file
var path = Path.Combine(appSettings.ImageUrlSave, fileName);
bool exists = System.IO.File.Exists(path);
// Getting Image
var image = documentDetails.Image;
try
{
if (!exists)
{
if (image.Length > 0)
{
using (var fileStream = new FileStream(path, FileMode.Create))
{
image.CopyTo(fileStream);
}
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
}
#endregion
#region save file details in DB
var dbItem = db.UnitworkccsDocumentuploadermaster.Where(m => m.DocumnetUploaderId == documentDetails.documentUploaderId && m.Isdeleted == 0 && m.Isactive == 1).FirstOrDefault();
if (dbItem == null)
{
#region insert item into DB
UnitworkccsDocumentuploadermaster documentUplodedMaster = new UnitworkccsDocumentuploadermaster();
documentUplodedMaster.DocumentName = documentDetails.Image.FileName;
documentUplodedMaster.FileName = fileName;
documentUplodedMaster.FilePath = path;
documentUplodedMaster.CreatedOn = DateTime.Now;
documentUplodedMaster.CreatedBy = 0;
documentUplodedMaster.Isdeleted = 0;
documentUplodedMaster.Isactive = 1;
// documentUplodedMaster.DocumnetUploaderFor = documentDetails.DocumentUploadedFor;
db.UnitworkccsDocumentuploadermaster.Add(documentUplodedMaster);
db.SaveChanges();
response.id = documentUplodedMaster.DocumnetUploaderId;
var doc = appSettings.ImageUrl +
(from wfd in db.UnitworkccsDocumentuploadermaster
where wfd.Isdeleted == 0 && wfd.DocumnetUploaderId == documentUplodedMaster.DocumnetUploaderId
select wfd.FileName).FirstOrDefault();
response.url = doc;
#endregion
}
else
{
#region delete old files
try
{
var deleteFileName = Path.Combine(appSettings.ImageUrlSave, dbItem.FileName);
if (deleteFileName != null || deleteFileName != string.Empty)
{
if ((System.IO.File.Exists(deleteFileName)))
{
System.IO.File.Delete(deleteFileName);
}
}
}
catch (Exception ex)
{
}
#endregion
#region update into DB
dbItem.FileName = fileName;
dbItem.DocumentName = documentDetails.Image.FileName;
// dbItem.DocumnetUploaderFor = documentDetails.DocumentUploadedFor;
dbItem.FilePath = path;
dbItem.ModifiedOn = DateTime.Now;
dbItem.ModifiedBy = 0;
db.SaveChanges();
response.id = documentDetails.documentUploaderId;
var doc = appSettings.ImageUrl +
(from wfd in db.UnitworkccsDocumentuploadermaster
where wfd.Isdeleted == 0 && wfd.DocumnetUploaderId == dbItem.DocumnetUploaderId
select wfd.FileName).FirstOrDefault();
response.url = doc;
#endregion
}
#endregion
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
response.isStatus = false;
response.response = ResourceResponse.ExceptionMessage;
}
response.isStatus = true;
response.response = ResourceResponse.FileUploaderSuccess;
}
else
{
response.isStatus = false;
response.response = ResourceResponse.FileUploaderFailure;
}
return(response);
}
/// <summary>
/// Add Rejection Details
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddRejectionDetails(AddRejection data)
{
CommonResponse obj = new CommonResponse();
try
{
CommonFunction commonFunction = new CommonFunction();
string shift = commonFunction.GetCurrentShift();
addedResopnse addresopnce = new addedResopnse();
string correctedDate = commonFunction.GetCorrectedDate();
if (data.dmcCodeStatus == "Enable")
{
if (data.actual > 1)
{
var check = db.UnitworkccsTblrejectiondetails.Where(m => m.QrCodeNo == data.qrCodeNo).FirstOrDefault();
if (check == null)
{
var dbCheck = db.UnitworkccsTblreworkdetails.Where(m => m.QrCodeNo == data.qrCodeNo).FirstOrDefault();
if (dbCheck == null)
{
UnitworkccsTblrejectiondetails UnitworkccsTblrejectiondetails = new UnitworkccsTblrejectiondetails();
UnitworkccsTblrejectiondetails.DefectCodeId = data.defectCodeId;
UnitworkccsTblrejectiondetails.DefectQty = 1;
UnitworkccsTblrejectiondetails.MachineId = data.machineId;
UnitworkccsTblrejectiondetails.OperatorId = data.operatorId;
UnitworkccsTblrejectiondetails.IsDeleted = 0;
UnitworkccsTblrejectiondetails.Shift = shift;
UnitworkccsTblrejectiondetails.FgPartId = data.fgPartId;
UnitworkccsTblrejectiondetails.CorrectedDate = correctedDate;
UnitworkccsTblrejectiondetails.CreatedOn = DateTime.Now;
UnitworkccsTblrejectiondetails.QrCodeNo = data.qrCodeNo;
UnitworkccsTblrejectiondetails.DmcCodeStatus = data.dmcCodeStatus;
UnitworkccsTblrejectiondetails.ReasonForRejection = data.reasonForRejection;
db.UnitworkccsTblrejectiondetails.Add(UnitworkccsTblrejectiondetails);
db.SaveChanges();
obj.isStatus = true;
// obj.response = ResourceResponse.AddedSuccessMessage;
var reLast = db.UnitworkccsTblrejectiondetails.Where(m => m.IsDeleted == 0).LastOrDefault();
var fgpartdet = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == data.fgPartId).FirstOrDefault();
var cellid = db.UnitworkccsTblfgandcellallocation.Where(m => m.PartNo == fgpartdet.FgPartNo).FirstOrDefault();
var cellname = db.UnitworkccsTblshop.Where(m => m.ShopId == cellid.CellFinalId).Select(m => m.ShopName).FirstOrDefault();
var subcellname = db.UnitworkccsTblcell.Where(m => m.CellId == cellid.SubCellFinalId).Select(m => m.CellName).FirstOrDefault();
var defectcode = db.UnitworkccsTbldefectcodemaster.Where(m => m.DefectCodeId == data.defectCodeId).FirstOrDefault();
var empno = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == fgpartdet.OperatorId).Select(m => m.OpNo).FirstOrDefault();
int?machineid = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == fgpartdet.FgPartId).Select(m => m.MachineId).FirstOrDefault();
var machinedet = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == (int)machineid).FirstOrDefault();
var plantcode = db.UnitworkccsTblplant.Where(m => m.PlantId == machinedet.PlantId).Select(m => m.PlantCode).FirstOrDefault();
var operatorname = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == fgpartdet.OperatorId).Select(m => m.OperatorName).FirstOrDefault();
addresopnce.cellId = (int)cellid.CellFinalId;
addresopnce.cellName = cellname;
addresopnce.subCellId = (int)cellid.SubCellFinalId;
addresopnce.subCellName = subcellname;
// addresopnce.date = Convert.ToString(fgpartdet.StartDate);
DateTime date1 = Convert.ToDateTime(fgpartdet.StartDate);
addresopnce.date = date1.ToString("yyyy-MM-ddTHH:mm:ss.fffZ");
// DateTime.Now.ToString("yyyy’-‘MM’-‘dd’T’HH’:’mm’:’ss.fffffffK")
addresopnce.defectCodeId = data.defectCodeId;
addresopnce.defectCode = defectcode.DefectCodeName;
addresopnce.defectDescription = defectcode.DefectCodeDesc;
addresopnce.employeeNo = (int)empno;
addresopnce.fgPartId = fgpartdet.FgPartId;
addresopnce.isRejectionOrRework = "Rejection";
addresopnce.machineId = (int)machineid;
string[] machinename = machinedet.MachineName.Split('_');
addresopnce.machineName = machinename[1];
addresopnce.operatorId = (int)fgpartdet.OperatorId;
addresopnce.operatorName = operatorname;
addresopnce.partDescription = fgpartdet.PartName;
addresopnce.partId = null;
addresopnce.partNumber = fgpartdet.FgPartNo;
addresopnce.partQrCode = data.qrCodeNo;
addresopnce.plantId = (int)machinedet.PlantId;
addresopnce.plantName = plantcode;
addresopnce.quantity = (int)reLast.DefectQty;
addresopnce.rejectionId = reLast.RejectionId;
addresopnce.reworkId = 0;
addresopnce.shift = fgpartdet.Shift;
addresopnce.updatedRejectionOrRework = null;
addresopnce.workorderNumber = fgpartdet.WorkOrderNo;
addresopnce.reasonForRejection = reLast.ReasonForRejection;
obj.response = addresopnce;
}
else
{
obj.isStatus = false;
obj.response = "Qr Code already Added";
}
}
else
{
obj.isStatus = false;
obj.response = "Qr Code already Added";
}
}
else
{
obj.isStatus = false;
obj.response = "Please enter Defect Qty less than Actal value" + data.actual;
}
}
else
{
if (data.actual > 1)
{
UnitworkccsTblrejectiondetails UnitworkccsTblrejectiondetails = new UnitworkccsTblrejectiondetails();
UnitworkccsTblrejectiondetails.DefectCodeId = data.defectCodeId;
UnitworkccsTblrejectiondetails.DefectQty = data.defectQty;
UnitworkccsTblrejectiondetails.MachineId = data.machineId;
UnitworkccsTblrejectiondetails.OperatorId = data.operatorId;
UnitworkccsTblrejectiondetails.IsDeleted = 0;
UnitworkccsTblrejectiondetails.Shift = shift;
UnitworkccsTblrejectiondetails.FgPartId = data.fgPartId;
UnitworkccsTblrejectiondetails.CorrectedDate = correctedDate;
UnitworkccsTblrejectiondetails.CreatedOn = DateTime.Now;
UnitworkccsTblrejectiondetails.DmcCodeStatus = data.dmcCodeStatus;
UnitworkccsTblrejectiondetails.ReasonForRejection = data.reasonForRejection;
db.UnitworkccsTblrejectiondetails.Add(UnitworkccsTblrejectiondetails);
db.SaveChanges();
obj.isStatus = true;
// obj.response = ResourceResponse.AddedSuccessMessage;
var reLast = db.UnitworkccsTblrejectiondetails.Where(m => m.IsDeleted == 0).LastOrDefault();
var fgpartdet = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == data.fgPartId).FirstOrDefault();
var cellid = db.UnitworkccsTblfgandcellallocation.Where(m => m.PartNo == fgpartdet.FgPartNo).FirstOrDefault();
var cellname = db.UnitworkccsTblshop.Where(m => m.ShopId == cellid.CellFinalId).Select(m => m.ShopName).FirstOrDefault();
var subcellname = db.UnitworkccsTblcell.Where(m => m.CellId == cellid.SubCellFinalId).Select(m => m.CellName).FirstOrDefault();
var defectcode = db.UnitworkccsTbldefectcodemaster.Where(m => m.DefectCodeId == data.defectCodeId).FirstOrDefault();
var empno = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == fgpartdet.OperatorId).Select(m => m.OpNo).FirstOrDefault();
int?machineid = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == fgpartdet.FgPartId).Select(m => m.MachineId).FirstOrDefault();
var machinedet = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == (int)machineid).FirstOrDefault();
var plantcode = db.UnitworkccsTblplant.Where(m => m.PlantId == machinedet.PlantId).Select(m => m.PlantCode).FirstOrDefault();
var operatorname = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == fgpartdet.OperatorId).Select(m => m.OperatorName).FirstOrDefault();
addresopnce.cellId = (int)cellid.CellFinalId;
addresopnce.cellName = cellname;
addresopnce.subCellId = (int)cellid.SubCellFinalId;
addresopnce.subCellName = subcellname;
// addresopnce.date = Convert.ToString(fgpartdet.StartDate);
DateTime date1 = Convert.ToDateTime(fgpartdet.StartDate);
addresopnce.date = date1.ToString("yyyy-MM-ddTHH:mm:ss.fffZ");
addresopnce.defectCodeId = data.defectCodeId;
addresopnce.defectCode = defectcode.DefectCodeName;
addresopnce.defectDescription = defectcode.DefectCodeDesc;
addresopnce.employeeNo = (int)empno;
addresopnce.fgPartId = fgpartdet.FgPartId;
addresopnce.isRejectionOrRework = "Rejection";
addresopnce.machineId = (int)machineid;
string[] machinename = machinedet.MachineName.Split('_');
addresopnce.machineName = machinename[1];
addresopnce.operatorId = (int)fgpartdet.OperatorId;
addresopnce.operatorName = operatorname;
addresopnce.partDescription = fgpartdet.PartName;
addresopnce.partId = null;
addresopnce.partNumber = fgpartdet.FgPartNo;
addresopnce.partQrCode = data.qrCodeNo;
addresopnce.plantId = (int)machinedet.PlantId;
addresopnce.plantName = plantcode;
addresopnce.quantity = (int)reLast.DefectQty;
addresopnce.rejectionId = reLast.RejectionId;
addresopnce.reworkId = 0;
addresopnce.shift = fgpartdet.Shift;
addresopnce.updatedRejectionOrRework = null;
addresopnce.workorderNumber = fgpartdet.WorkOrderNo;
addresopnce.reasonForRejection = reLast.ReasonForRejection;
obj.response = addresopnce;
}
else
{
obj.isStatus = false;
obj.response = "Please enter Defect Qty less than Actal value" + data.actual;
}
}
}
catch (Exception ex)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Upload Escalation Matrix Details
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse UploadEscalationMatrixDetails(List <EscalationMatrixDetails> data)
{
CommonResponse obj = new CommonResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
var dbCheck = db.UnitworkccsTblescalationmatrix.Where(m => m.IsDeleted == 0).ToList();
db.RemoveRange(dbCheck);
db.SaveChanges();
foreach (var item in data)
{
var check = db.UnitworkccsTblescalationmatrix.Where(m => m.OpNo == item.employeeId).FirstOrDefault();
if (check == null)
{
UnitworkccsTblescalationmatrix tblEscalationMatrix = new UnitworkccsTblescalationmatrix();
tblEscalationMatrix.Category = item.category;
string idsss = "";
if (string.IsNullOrEmpty(item.category))
{
tblEscalationMatrix.CategoryId = idsss;
}
else
{
string[] catSlipt = item.category.Split(',');
List <string> catlist = catSlipt.ToList();
foreach (var val in catlist)
{
var catid = db.UnitworkccsTblcategorymaster.Where(m => m.CategoryName == val).Select(m => m.CategoryId).FirstOrDefault();
string ids = catid + ",";
idsss = idsss + ids;
}
idsss = idsss.TrimStart(',');
idsss = idsss.TrimEnd(',');
tblEscalationMatrix.CategoryId = idsss;
}
tblEscalationMatrix.Cell = item.cell;
string cellids = "";
if (string.IsNullOrEmpty(item.cell))
{
tblEscalationMatrix.CellId = cellids;
}
else
{
string[] cellSplit = item.cell.Split(',');
List <string> cell = cellSplit.ToList();
foreach (var val in cell)
{
var celid = db.UnitworkccsTblshop.Where(m => m.ShopName == val).Select(m => m.ShopId).FirstOrDefault();
string ids = celid + ",";
cellids = cellids + ids;
}
cellids = cellids.TrimStart(',');
cellids = cellids.TrimEnd(',');
tblEscalationMatrix.CellId = cellids;
}
// tblEscalationMatrix.ContactNo = item.contactNo;
tblEscalationMatrix.EmployeeId = db.UnitworkccsTbloperatordetails.Where(m => m.OperatorName == item.employeeName).Select(m => m.OpId).FirstOrDefault();
tblEscalationMatrix.EmployeeName = item.employeeName;
// tblEscalationMatrix.MachineId = db.Tblmachinedetails.Where(m => m.MachineName == item.machineName).Select(m => m.MachineId).FirstOrDefault();
// tblEscalationMatrix.MachineName = item.machineName;
tblEscalationMatrix.OpNo = item.employeeId;
// tblEscalationMatrix.Role = item.role;
// tblEscalationMatrix.RoleId = db.Tblroles.Where(m => m.RoleName == item.role).Select(m => m.RoleId).FirstOrDefault();
tblEscalationMatrix.Shift = item.shift;
// tblEscalationMatrix.ShiftId = db.TblshiftMstr.Where(m => m.ShiftName == item.shift).Select(m => m.ShiftId).FirstOrDefault();
tblEscalationMatrix.SmsPriority = item.smsPriority;
tblEscalationMatrix.SubCell = item.subCell;
string subcellids = "";
if (string.IsNullOrEmpty(item.subCell))
{
tblEscalationMatrix.SubCellId = subcellids;
}
else
{
string[] subcellSplit = item.subCell.Split(',');
List <string> subcell = subcellSplit.ToList();
foreach (var val in subcell)
{
var subcelid = db.UnitworkccsTblcell.Where(m => m.CellName == val).Select(m => m.CellId).FirstOrDefault();
string ids = subcelid + ",";
subcellids = subcellids + ids;
}
subcellids = subcellids.TrimStart(',');
subcellids = subcellids.TrimEnd(',');
tblEscalationMatrix.SubCellId = subcellids;
}
// tblEscalationMatrix.TimeToBeTriggered = timeToBeTriggered;
tblEscalationMatrix.IsDeleted = 0;
tblEscalationMatrix.CreatedOn = DateTime.Now;
db.UnitworkccsTblescalationmatrix.Add(tblEscalationMatrix);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
// }
}
else
{
check.Category = item.category;
string idsss = "";
if (string.IsNullOrEmpty(item.category))
{
check.CategoryId = idsss;
}
else
{
string[] catSlipt = item.category.Split(',');
List <string> catlist = catSlipt.ToList();
foreach (var val in catlist)
{
var catid = db.UnitworkccsTblcategorymaster.Where(m => m.CategoryName == val).Select(m => m.CategoryId).FirstOrDefault();
string ids = catid + ",";
idsss = idsss + ids;
}
idsss = idsss.TrimStart(',');
idsss = idsss.TrimEnd(',');
check.CategoryId = idsss;
}
// check.PlantId = data.plantId;
// check.PlantCode = db.Tblplant.Where(m => m.PlantId == data.plantId).Select(m => m.PlantCode).FirstOrDefault();
check.Cell = item.cell;
string cellids = "";
if (string.IsNullOrEmpty(item.cell))
{
check.CellId = cellids;
}
else
{
string[] cellSplit = item.cell.Split(',');
List <string> cell = cellSplit.ToList();
foreach (var val in cell)
{
var celid = db.UnitworkccsTblshop.Where(m => m.ShopName == val).Select(m => m.ShopId).FirstOrDefault();
string ids = celid + ",";
cellids = cellids + ids;
}
cellids = cellids.TrimStart(',');
cellids = cellids.TrimEnd(',');
check.CellId = cellids;
}
// check.ContactNo = data.contactNo;
check.EmployeeId = db.UnitworkccsTbloperatordetails.Where(m => m.OperatorName == item.employeeName).Select(m => m.OpId).FirstOrDefault();
check.EmployeeName = item.employeeName;
check.OpNo = item.employeeId;
check.Shift = item.shift;
//check.ShiftId = db.TblshiftMstr.Where(m => m.ShiftName == item.shift).Select(m => m.ShiftId).FirstOrDefault();
check.SmsPriority = item.smsPriority;
check.SubCell = item.subCell;
string subcellids = "";
if (string.IsNullOrEmpty(item.cell))
{
check.SubCellId = subcellids;
}
else
{
string[] subcellSplit = item.subCell.Split(',');
List <string> subcell = subcellSplit.ToList();
foreach (var val in subcell)
{
var subcelid = db.UnitworkccsTblcell.Where(m => m.CellName == val).Select(m => m.CellId).FirstOrDefault();
string ids = subcelid + ",";
subcellids = subcellids + ids;
}
subcellids = subcellids.TrimStart(',');
subcellids = subcellids.TrimEnd(',');
check.SubCellId = subcellids;
}
// check.TimeToBeTriggered = timeToBeTriggered;
check.IsDeleted = 0;
check.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
//}
}
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
///// <summary>
///// Login Details
///// </summary>
///// <param name="userName"></param>
///// <param name="password"></param>
///// <returns></returns>
//public CommonResponse LoginDetails(string userName,string password)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var check = (from wf in db.TblOperatorDetails
// where wf.UserName == userName && wf.Password == password && wf.IsDeleted == 0
// select new
// {
// wf.OpId,
// wf.OperatorName,
// wf.RoleId,
// }).FirstOrDefault();
// if(check != null)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
/// <summary>
/// Login Details
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <returns></returns>
public CommonResponse LoginDetails(LoginTrackerdetails data)
{
CommonResponse obj = new CommonResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
string shift = commonFunction.GetCurrentShift();
string correctedDate = commonFunction.GetCorrectedDate();
int machineId = data.machineId;
CommonResponse commonResponse = new CommonResponse();
List <LoginOperatorDet> loginOperatorDetsList = new List <LoginOperatorDet>();
var loginTrackerDet = commonFunction.GetLoginTrackerDetailsLastRow(correctedDate, data.machineId);
if (loginTrackerDet == null)
{
var check = (from wf in db.UnitworkccsTbloperatordetails
where wf.UserName == data.userName && wf.Password == data.password && wf.IsDeleted == 0
select new
{
wf.OpId,
wf.OperatorName,
wf.RoleId,
}).FirstOrDefault();
if (check != null)
{
if (check.RoleId == 6 && data.pageName == "operatorPage")
{
UnitworkccsLogintrackerdetails loginTrackerDetails = new UnitworkccsLogintrackerdetails();
loginTrackerDetails.MachineId = machineId;
loginTrackerDetails.OperatorId = check.OpId;
loginTrackerDetails.LoginDateTime = DateTime.Now;
loginTrackerDetails.IsLoggedIn = 1;
loginTrackerDetails.Shift = shift;
loginTrackerDetails.CorrectedDate = correctedDate;
db.UnitworkccsLogintrackerdetails.Add(loginTrackerDetails);
db.SaveChanges();
LoginOperatorDet loginOperatorDet = new LoginOperatorDet();
loginOperatorDet.opId = check.OpId;
loginOperatorDet.operatorName = check.OperatorName;
loginOperatorDet.roleId = check.RoleId;
loginOperatorDet.machineName = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == machineId).Select(m => m.MachineName).FirstOrDefault();
DateTime LoginDateTime = Convert.ToDateTime(loginTrackerDetails.LoginDateTime);
loginOperatorDet.loginTime = LoginDateTime.ToString("yyyy-MM-dd HH:mm:ss");
loginOperatorDet.shift = loginTrackerDetails.Shift;
loginOperatorDet.correctedDate = loginTrackerDetails.CorrectedDate;
loginOperatorDetsList.Add(loginOperatorDet);
obj.isStatus = true;
obj.response = loginOperatorDetsList;
}
else if (check.RoleId == 9 && data.pageName == "ticketManagement")
{
UnitworkccsLogintrackerdetails loginTrackerDetails = new UnitworkccsLogintrackerdetails();
loginTrackerDetails.MachineId = machineId;
loginTrackerDetails.OperatorId = check.OpId;
loginTrackerDetails.LoginDateTime = DateTime.Now;
loginTrackerDetails.IsLoggedIn = 1;
loginTrackerDetails.Shift = shift;
loginTrackerDetails.CorrectedDate = correctedDate;
db.UnitworkccsLogintrackerdetails.Add(loginTrackerDetails);
db.SaveChanges();
LoginOperatorDet loginOperatorDet = new LoginOperatorDet();
loginOperatorDet.opId = check.OpId;
loginOperatorDet.operatorName = check.OperatorName;
loginOperatorDet.roleId = check.RoleId;
loginOperatorDet.machineName = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == machineId).Select(m => m.MachineName).FirstOrDefault();
DateTime LoginDateTime = Convert.ToDateTime(loginTrackerDetails.LoginDateTime);
loginOperatorDet.loginTime = LoginDateTime.ToString("yyyy-MM-dd HH:mm:ss");
loginOperatorDet.shift = loginTrackerDetails.Shift;
loginOperatorDet.correctedDate = loginTrackerDetails.CorrectedDate;
loginOperatorDetsList.Add(loginOperatorDet);
obj.isStatus = true;
obj.response = loginOperatorDetsList;
}
else
{
obj.isStatus = false;
obj.response = "Not Authorized User";
}
}
else
{
obj.isStatus = false;
obj.response = ResourceResponse.NoItemsFound;
}
}
else
{
obj.isStatus = false;
obj.response = "Already Logged In";
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
///// <summary>
///// Get WorkOrder No
///// </summary>
///// <param name="machineId"></param>
///// <returns></returns>
//public CommonResponse GetWorkOrderNo(int machineId)
//{
// CommonResponse obj = new CommonResponse();
// CommonFunction commonFunction = new CommonFunction();
// string shift = commonFunction.GetCurrentShift();
// try
// {
// var check = db.Tblmachinedetails.Where(m => m.MachineId == machineId).Select(m => m.MachineName).FirstOrDefault();
// var shiftId = db.TblshiftMstr.Where(m => m.ShiftName == shift).Select(m => m.ShiftId).FirstOrDefault();
// var dbCheck = (from wf in db.TblPlanLinkageMaster
// where wf.ResourceId == check && wf.ShiftId == shiftId
// select new
// {
// ProductionOrder = wf.ProductionOrder,
// PlanLinkageId = wf.PlanLinkageId
// }).ToList();
// if (dbCheck.Count > 0)
// {
// obj.isStatus = true;
// obj.response = dbCheck;
// }
// else
// {
// obj.isStatus = false;
// obj.response = "No Items Found";
// }
// }
// catch (Exception ex)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
///// <summary>
///// View Multiple Part No
///// </summary>
///// <param name="ProductionOrder"></param>
///// <returns></returns>
//public CommonResponse ViewMultiplePartNo(string ProductionOrder, int PlanLinkageId)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var check = (from wf in db.TblPlanLinkageMaster
// where wf.IsDeleted == 0 && wf.ProductionOrder == ProductionOrder && wf.PlanLinkageId == PlanLinkageId
// select new
// {
// FgPartNo = wf.FgPartNo,
// PlanLinkageId = wf.PlanLinkageId
// }).ToList();
// if (check.Count > 0)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
///// <summary>
///// Get Operation No
///// </summary>
///// <param name="FgPartNo"></param>
///// <returns></returns>
//public CommonResponse GetOperationNo(string FgPartNo, int PlanLinkageId)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var check = (from wf in db.TblPlanLinkageMaster
// where wf.IsDeleted == 0 && wf.FgPartNo == FgPartNo && wf.PlanLinkageId == PlanLinkageId
// select new
// {
// OperationNo = wf.Operation,
// RoutingId = wf.RoutingId,
// PlanLinkageId = wf.PlanLinkageId
// }).ToList();
// if (check.Count > 0)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
///// <summary>
///// Get WorkOrder Qty
///// </summary>
///// <param name="operationNo"></param>
///// <returns></returns>
//public CommonResponse GetWorkOrderQty(int operationNo, int PlanLinkageId)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var check = (from wf in db.TblPlanLinkageMaster
// where wf.IsDeleted == 0 && wf.Operation == operationNo && wf.PlanLinkageId == PlanLinkageId
// select new
// {
// WorkOrderQty = wf.WorkOrderQty,
// PlanLinkageId = wf.PlanLinkageId
// }).ToList();
// if (check.Count > 0)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
///// <summary>
///// View Multiple Part No
///// </summary>
///// <param name="opearationNo"></param>
///// <returns></returns>
//public CommonResponse ViewMultiplePartNo(int opearationNo,int machineId)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var machineName = db.Tblmachinedetails.Where(m => m.MachineId == machineId).Select(m => m.MachineName).FirstOrDefault();
// var check = (from wf in db.Tblparts
// where wf.IsDeleted == 0 && wf.OperationNo == Convert.ToString(opearationNo) && wf.ResourceId == machineName
// select new
// {
// PartId = wf.PartId,
// PartNo = wf.Fgcode
// }).ToList();
// if (check.Count > 0)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
/// <summary>
/// Add Update Fg Part No
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public GeneralResponse AddUpdateFgPartNo(AddUpdateFgPartNo data)
{
GeneralResponse obj = new GeneralResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
string shift = commonFunction.GetCurrentShift();
string correctedDate = commonFunction.GetCorrectedDate();
var loginTrackerDetails = commonFunction.GetLoginTrackerDetailsLastRow(correctedDate, data.machineId);
var machineName = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == data.machineId && m.IsDeleted == 0).Select(m => m.MachineName).FirstOrDefault();
if (loginTrackerDetails != null)
{
#region Add and Update FGPart
var check = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == data.fgPartId).FirstOrDefault();
if (check == null)
{
UnitworkccsTblfgpartnodet tblFgPartNoDet = new UnitworkccsTblfgpartnodet();
tblFgPartNoDet.OperationNo = data.operationNo;
tblFgPartNoDet.NoOfPartsPerCycle = data.noOfPartsPerCycle;
tblFgPartNoDet.PartCountMethod = data.partsCountMethod;
tblFgPartNoDet.WorkOrderNo = data.workOrderNo;
tblFgPartNoDet.IsDeleted = 0;
tblFgPartNoDet.CreatedOn = DateTime.Now;
tblFgPartNoDet.MachineId = data.machineId;
tblFgPartNoDet.OperatorId = data.operatorId;
tblFgPartNoDet.MachineId = data.machineId;
tblFgPartNoDet.CorrectedDate = correctedDate;
tblFgPartNoDet.StartDate = DateTime.Now;
tblFgPartNoDet.Shift = shift;
tblFgPartNoDet.TargetQty = 0;
tblFgPartNoDet.ActaulValue = 0;
tblFgPartNoDet.PlanLinkageId = data.planLinkageId;
var planVisageData = (from wf in db.UnitworkccsTblplanlinkagemaster
where wf.PlanLinkageId == data.planLinkageId
select new
{
idealCycleTime = wf.IdealCycleTime,
fgPartNo = wf.FgPartNo,
plannedStartTime = wf.PlannedStartTime,
plannedEndTime = wf.PlannedEndTime,
unit = wf.Unit,
scheduledQty = wf.ScheduledQty,
partName = wf.PartName,
routingId = wf.RoutingId,
workOrderCompletedQty = wf.WorkOrderCompletedQty
}).FirstOrDefault();
if (planVisageData != null)
{
tblFgPartNoDet.FgPartNo = planVisageData.fgPartNo;
tblFgPartNoDet.IdealCycleTime = planVisageData.idealCycleTime;
tblFgPartNoDet.Unit = planVisageData.unit;
tblFgPartNoDet.Unit = planVisageData.unit;
tblFgPartNoDet.PlannedStartTime = planVisageData.plannedStartTime;
tblFgPartNoDet.PlannedEndTime = planVisageData.plannedEndTime;
tblFgPartNoDet.PartName = planVisageData.partName;
tblFgPartNoDet.ScheduledQty = planVisageData.scheduledQty;
tblFgPartNoDet.RoutingId = planVisageData.routingId;
tblFgPartNoDet.WorkOrderCompletedQty = planVisageData.workOrderCompletedQty;
}
db.UnitworkccsTblfgpartnodet.Add(tblFgPartNoDet);
db.SaveChanges();
obj.fgPartId = tblFgPartNoDet.FgPartId;
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
obj.partNo = db.UnitworkccsTblplanlinkagemaster.Where(m => m.PlanLinkageId == tblFgPartNoDet.PlanLinkageId).Select(m => m.FgPartNo).FirstOrDefault();
}
else
{
//var fgPartNo = db.TblPlanLinkageMaster.Where(m => m.PlanLinkageId == data.partId).Select(m => m.FgPartNo).FirstOrDefault();
//var partId = db.Tblparts.Where(m => m.Fgcode == fgPartNo && m.ResourceId == machineName).Select(m => m.PartId).FirstOrDefault();
//if (partId > 0)
//{
// check.PartId = partId;
//}
//check.PartId = data.partId;
check.OperationNo = data.operationNo;
check.NoOfPartsPerCycle = data.noOfPartsPerCycle;
check.PartCountMethod = data.partsCountMethod;
check.WorkOrderNo = data.workOrderNo;
check.IsDeleted = 0;
check.ModifiedOn = DateTime.Now;
check.OperatorId = data.operatorId;
check.MachineId = data.machineId;
check.CorrectedDate = correctedDate;
check.PlanLinkageId = data.planLinkageId;
check.Shift = shift;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
obj.fgPartId = check.FgPartId;
obj.partNo = db.UnitworkccsTblplanlinkagemaster.Where(m => m.PlanLinkageId == check.PlanLinkageId).Select(m => m.FgPartNo).FirstOrDefault();
}
#endregion
#region Update last row of logged in user details
loginTrackerDetails.CurrentFgpart = obj.fgPartId;
db.UnitworkccsLogintrackerdetails.Update(loginTrackerDetails);
db.SaveChanges();
#endregion
}
else
{
obj.isStatus = false;
obj.response = ResourceResponse.LoginAgain;
}
}
catch (Exception e)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
commonFunction.LogFile(obj.response);
return(obj);
}
/// <summary>
/// Add And Update Machine Master
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddAndUpdateMachineMaster(AddUpdateMachine data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == data.machineId).FirstOrDefault();
if (check == null)
{
try
{
UnitworkccsTblmachinedetails tblmachinedetails = new UnitworkccsTblmachinedetails();
tblmachinedetails.PlantId = data.plantId;
tblmachinedetails.ShopId = data.shopId;
tblmachinedetails.CellId = data.cellId;
tblmachinedetails.Ipaddress = data.ipAddress;
tblmachinedetails.MachineName = data.machineNo;
tblmachinedetails.MachineDisplayName = data.machineNo;
tblmachinedetails.MachinePockets = Convert.ToInt32(data.noOfToolStation);
tblmachinedetails.Mmmgroup = data.mmmGroup;
tblmachinedetails.MachineDescription = data.machineName;
tblmachinedetails.DedicatedOrShared = data.dedicatedOrShared;
tblmachinedetails.PrimaryOrSecondary = data.primaryOrSecondary;
tblmachinedetails.MachineCategoryId = data.machineCategoryId;
tblmachinedetails.MachineMake = Convert.ToString(data.makeId);
tblmachinedetails.MachineSpec = data.machineSpec;
tblmachinedetails.ChuckOrRodSize = Convert.ToInt32(data.chuckOrRodSize);
tblmachinedetails.TallStockAvailId = Convert.ToInt32(data.tallStockAvailibilityId);
tblmachinedetails.NoOfAxisId = Convert.ToInt32(data.noOfAxisId);
tblmachinedetails.TableSize = data.tableSize;
tblmachinedetails.PalletId = Convert.ToInt32(data.palletId);
tblmachinedetails.Category = data.criticalOrNonCritical;
if (data.machineBelongTo == "Wimarasys")
{
tblmachinedetails.IsWimerasys = 1;
tblmachinedetails.MachineModelType = 99;
}
else
{
if (data.controllerType == "FANUC")
{
tblmachinedetails.ControllerType = "FANUC";
tblmachinedetails.MachineModelType = 1;
}
else if (data.controllerType == "DL")
{
tblmachinedetails.ControllerType = "DL";
tblmachinedetails.IsPcb = 1;
tblmachinedetails.MachineModelType = 4;
}
}
tblmachinedetails.IsNormalWc = 0;
tblmachinedetails.CreatedOn = DateTime.Now;
tblmachinedetails.InsertedOn = Convert.ToString(DateTime.Now);
tblmachinedetails.InsertedBy = 1;
tblmachinedetails.EnableLockLogic = 0;
tblmachinedetails.ServerTabFlagSync = 0;
tblmachinedetails.ServerTabCheck = 0;
tblmachinedetails.IsShiftWise = 0;
tblmachinedetails.IsDeleted = 0;
tblmachinedetails.IsDlversion = 0;
db.UnitworkccsTblmachinedetails.Add(tblmachinedetails);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
}
else
{
check.PlantId = data.plantId;
check.ShopId = Convert.ToInt32(data.shopId);
check.CellId = Convert.ToInt32(data.cellId);
check.Ipaddress = data.ipAddress;
check.MachineName = data.machineNo;
check.MachineDisplayName = data.machineName;
check.MachinePockets = Convert.ToInt32(data.noOfToolStation);
check.Mmmgroup = data.mmmGroup;
check.MachineDescription = data.machineName;
check.DedicatedOrShared = data.dedicatedOrShared;
check.PrimaryOrSecondary = data.primaryOrSecondary;
check.MachineCategoryId = data.machineCategoryId;
check.MachineMake = Convert.ToString(data.makeId);
check.MachineSpec = data.machineSpec;
check.ChuckOrRodSize = Convert.ToInt32(data.chuckOrRodSize);
check.TallStockAvailId = Convert.ToInt32(data.tallStockAvailibilityId);
check.NoOfAxisId = Convert.ToInt32(data.noOfAxisId);
check.TableSize = data.tableSize;
check.PalletId = Convert.ToInt32(data.palletId);
check.Category = data.criticalOrNonCritical;
if (data.machineBelongTo == "Wimarasys")
{
check.IsWimerasys = 1;
check.MachineModelType = 99;
}
else
{
if (data.controllerType == "FANUC")
{
check.ControllerType = "FANUC";
check.MachineModelType = 1;
}
else if (data.controllerType == "DL")
{
check.ControllerType = "DL";
check.IsPcb = 1;
check.MachineModelType = 4;
}
}
check.IsNormalWc = 0;
check.CreatedOn = DateTime.Now;
check.InsertedOn = Convert.ToString(DateTime.Now);
check.InsertedBy = 1;
check.EnableLockLogic = 0;
check.ServerTabFlagSync = 0;
check.ServerTabCheck = 0;
check.IsShiftWise = 0;
check.IsDeleted = 0;
check.IsDlversion = 0;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
public CommonResponse ApproveCheckList(approveDetPM data)
{
CommonResponse obj = new CommonResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
var check = db.UnitworkccsTblchecklistHeader.Where(m => m.HeaderId == data.headerId && m.IsDeleted == 0).FirstOrDefault();
if (check != null)
{
var checkDet = db.UnitworkccsTblchecklistDetails.Where(m => m.CheckListId == data.checkListId && m.IsDeleted == 0 && m.HeaderId == data.headerId && m.RoleId == data.roleId).FirstOrDefault();
if (checkDet != null)
{
// checkDet.IsOk = data.isOk;
if (data.isOk == "1")
{
checkDet.IsDashBoardEntry = 1;
}
else if (data.isOk == "0")
{
checkDet.IsDashBoardEntry = 0;
}
else
{
checkDet.IsDashBoardEntry = null;
}
checkDet.Comment = data.comment;
checkDet.IsApproved = 1;
checkDet.NumericValue = data.numericValue;
checkDet.TextValue = data.textValue;
// checkDet.IsDashBoardEntry = 1;
db.SaveChanges();
check.ApprovedBy = data.approverId;
check.CreationDate = DateTime.Now;
check.LastRevDate = DateTime.Now;
check.ApprovedByDate = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
obj.isStatus = false;
obj.response = "checkList Id not found";
}
}
else
{
obj.isStatus = false;
obj.response = "Header Id not found";
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
