internal static WorkCenterFileModel Mapping(USR_TMMA_WORK_CENTER_FILE o)
{
try
{
if (o != null)
{
return(new WorkCenterFileModel()
{
WorkCenterFileID = o.WorkCenterFileID,
RecObjectName = o.RecObjectName,
UserSAP = o.UserSAP,
WorkCenterFilePath = o.WorkCenterFilePath,
WorkCenterFileVersion = o.WorkCenterFileVersion,
WorkCenterFileStatus = o.WorkCenterFileStatus,
FileStatus = FileStatusDAL.GetFileStatus(o.WorkCenterFileStatus),
ProductsTypeID = o.ProductsTypeID,
IsActive = o.IsActive == 1,
CreatedBy = o.CreatedBy,
CreatedDate = o.CreatedDate,
UpdatedBy = o.UpdatedBy,
UpdatedDate = o.UpdatedDate
});
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public static ResponseModel UpdateStatusWorkCenterFile(int WorkCenterFileID, int WorkCenterFileStatus)
{
string action = "UpdateStatusWorkCenterFile(WorkCenterFileID, WorkCenterFileStatus)";
try
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
USR_TMMA_WORK_CENTER_FILE _obj = context.USR_TMMA_WORK_CENTER_FILE.FirstOrDefault(o => o.WorkCenterFileID == WorkCenterFileID);
if (_obj != null)
{
_obj.WorkCenterFileStatus = WorkCenterFileStatus;
context.SaveChanges();
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = true,
Message = "Success"
});
}
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = "WorkCenterFileID Not Exist"
});
}
}
catch (DbEntityValidationException ex)
{
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = ex.Message,
StackTrace = ex.StackTrace
});
}
catch (Exception ex)
{
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = ex.Message,
StackTrace = ex.StackTrace
});
}
}
public static WorkCenterFileModel GetWorkCenterFile(int workCenterFileID)
{
ACTION = "GetWorkCenterFile(workCenterFileID)";
try
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
USR_TMMA_WORK_CENTER_FILE obj = context.USR_TMMA_WORK_CENTER_FILE.Where(o => o.WorkCenterFileID == workCenterFileID).FirstOrDefault();
WorkCenterFileModel m = Mapping(obj);
return(m);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static ResponseModel AddWorkCenterFile(WorkCenterFileModel m, ref int _newID)
{
string action = "AddWorkCenterFile(WorkCenterFileModel, out _newID)";
_newID = 0;
try
{
if (m != null)
{
using (UTMMABCDBEntities context = new UTMMABCDBEntities())
{
USR_TMMA_WORK_CENTER_FILE _obj = Mapping(m);
context.USR_TMMA_WORK_CENTER_FILE.Add(_obj);
if (context.SaveChanges() > 0)
{
_newID = _obj.WorkCenterFileID;
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = true,
Message = "Success"
});
}
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = "Fail"
});
}
}
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = "Null"
});
}
catch (DbEntityValidationException ex)
{
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = ex.Message,
StackTrace = ex.StackTrace
});
}
catch (Exception ex)
{
return(new ResponseModel()
{
Source = SOURCE,
Action = action,
Status = false,
Message = ex.Message,
StackTrace = ex.StackTrace
});
}
}
