private static ProjectInfo getFirstProject(DSMContext dbcontext)
{
var item = dbcontext.ProjectInfo.FirstOrDefault();
if (item == null)
{
item = new ProjectInfo();
item.Id = Guid.NewGuid();
item.Name = "测试工程。";
dbcontext.Add(item);
dbcontext.SaveChanges();
}
return(item);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditCheckListJobAssignedResource(CheckListJobAssignedResourceMasterCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
try
{
var res = db.CheckListJobAssignedResourceMaster.Where(m => m.CheckListJobMasterId == data.checkListJobMasterId && m.CheckListJobGroupId == data.checkListJobGroupId).FirstOrDefault();
if (res == null)
{
try
{
CheckListJobAssignedResourceMaster item = new CheckListJobAssignedResourceMaster();
item.CheckListJobMasterId = data.checkListJobMasterId;
item.CheckListJobGroupId = data.checkListJobGroupId;
item.PrimaryResource = data.primaryResource;
item.PrimaryResourceToAllFlag = data.primaryResourceToAllFlag;
item.SecondaryResource = data.secondaryResource;
item.SecondaryResourceToAllFlag = data.secondaryResourceToAllFlag;
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.CheckListJobAssignedResourceMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.CheckListJobMasterId = data.checkListJobMasterId;
res.CheckListJobGroupId = data.checkListJobGroupId;
res.PrimaryResource = data.primaryResource;
res.PrimaryResourceToAllFlag = data.primaryResourceToAllFlag;
res.SecondaryResource = data.secondaryResource;
res.SecondaryResourceToAllFlag = data.secondaryResourceToAllFlag;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditCheckListJobActivity(CheckListJobActivityCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
var res = db.CheckListJobActivityMaster.Where(m => m.CheckListJobActivityId == data.checkListJobActivityId).FirstOrDefault();
if (res == null)
{
try
{
var stepCount = commonFunction.ChangeCheckListAndJobStepNumberOfPreviousItem(data.checkListJobMasterId, data.checkListJobGroupId, "Activity", "Job");
CheckListJobActivityMaster item = new CheckListJobActivityMaster();
item.CheckListJobMasterId = data.checkListJobMasterId;
item.CheckListJobGroupId = data.checkListJobGroupId;
item.ActivitySubCategoryId = data.activitySubCategoryId;
item.CheckListJobStepNumber = stepCount + 1;
item.Remarks = data.remarks;
item.ActivityDescription = data.activityDescription;
item.IsActivityManditory = data.isActivityManditory;
item.IsPhotoManditory = data.isPhotoManditory;
item.IsBarCodeManditory = data.isBarCodeManditory;
try
{
item.ExpectedCompletionTime = data.expectedCompletionTime;
}
catch (Exception ex)
{ }
item.AssetId = data.assetId;
item.IsActive = true;
item.IsDeleted = false;
item.IsAdminApproved = true;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.CheckListJobActivityMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.CheckListJobMasterId = data.checkListJobMasterId;
res.CheckListJobGroupId = data.checkListJobGroupId;
res.ActivitySubCategoryId = data.activitySubCategoryId;
res.CheckListJobStepNumber = data.checkListJobStepNumber;
res.Remarks = data.remarks;
res.ActivityDescription = data.activityDescription;
res.IsActivityManditory = data.isActivityManditory;
res.IsPhotoManditory = data.isPhotoManditory;
res.IsBarCodeManditory = data.isBarCodeManditory;
res.AssetId = data.assetId;
try
{
res.ExpectedCompletionTime = data.expectedCompletionTime;
}
catch (Exception ex)
{ }
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditDesignation(DesignationCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
try
{
var res = db.DesignationMaster.Where(m => m.DesignationId == data.designationId).FirstOrDefault();
if (res == null)
{
try
{
DesignationMaster item = new DesignationMaster();
item.DesignationName = data.designationName;
item.DesignationDescription = data.designationDescription;
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.DesignationMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.DesignationName = data.designationName;
res.DesignationDescription = data.designationDescription;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditUser(UserDetailsCustom data, long usersId = 0)
{
CommonResponse obj = new CommonResponse();
Security security = new Security();
string passwordEncrypt = security.Encrypt(data.password);
try
{
var res = db.UserDetails.Where(m => m.UserId == data.userId).FirstOrDefault();
if (res == null)
{
try
{
UserDetails item = new UserDetails();
item.UserName = data.userName;
item.Password = passwordEncrypt;
item.UserFirstName = data.userFirstName;
item.UserLastName = data.userLastName;
item.UserFullName = data.userFullName;
item.EmailId = data.emailId;
item.PhoneNumber = data.phoneNumber;
item.RoleId = data.roleId;
item.DesignationId = data.designationId;
item.DepartmentId = data.departmentId;
item.ReportingManagerName = data.reportingManagerName;
item.ReportManagerId = data.reportingManagerId;
item.EmployeeUniqueCode = data.employeeUniqueCode;
item.DocumentUploadedId = data.documentUploadedId;
item.IsActive = true;
item.IsAdminApproved = true;
item.IsDeleted = false;
item.CreatedBy = usersId;
item.CreatedOn = DateTime.Now;
db.UserDetails.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.UserName = data.userName;
//res.Password = passwordEncrypt;
res.UserFirstName = data.userFirstName;
res.UserLastName = data.userLastName;
res.UserFullName = data.userFullName;
res.EmailId = data.emailId;
res.PhoneNumber = data.phoneNumber;
res.RoleId = data.roleId;
res.DesignationId = data.designationId;
res.DepartmentId = data.departmentId;
res.ReportingManagerName = data.reportingManagerName;
res.ReportManagerId = data.reportingManagerId;
res.EmployeeUniqueCode = data.employeeUniqueCode;
res.DocumentUploadedId = data.documentUploadedId;
res.ModifiedBy = usersId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditCheckListLOTOTO(CheckListLOTOTOCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
var res = db.CheckListLototomaster.Where(m => m.LototoCheckListId == data.checkListLOTOTOId).FirstOrDefault();
if (res == null)
{
try
{
var stepCount = commonFunction.ChangeCheckListAndJobStepNumberOfPreviousItem(data.checkListMasterId, data.checkListGroupId, "LOTOTO", "CheckList");
CheckListLototomaster item = new CheckListLototomaster();
item.CheckListMasterId = data.checkListMasterId;
item.CheckListGroupId = data.checkListGroupId;
item.CheckListLockStepNumber = stepCount + 1;
item.PositionDescription = data.positionDescription;
item.IsLockOutRequired = data.isLockOutRequired;
item.IsTagOutRequired = data.isTagOutRequired;
item.IsTryOutRequired = data.isTryOutRequired;
item.Remarks = data.remarks;
item.IsActive = true;
item.IsDeleted = false;
item.IsAdminApproved = true;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.CheckListLototomaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.CheckListMasterId = data.checkListMasterId;
res.CheckListGroupId = data.checkListGroupId;
res.CheckListLockStepNumber = data.checkListLockStepNumber;
res.PositionDescription = data.positionDescription;
res.IsLockOutRequired = data.isLockOutRequired;
res.IsTagOutRequired = data.isTagOutRequired;
res.IsTryOutRequired = data.isTryOutRequired;
res.Remarks = data.remarks;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
///
//public CommonResponseWithIds AddAndEditCheckListJobOperator(CheckListJobOperatorCustom data, long userId = 0)
//{
// CommonResponseWithIds obj = new CommonResponseWithIds();
// try
// {
// var res = db.CheckListJobWrtoperator.Where(m => m.CheckListJobMasterId == data.checkListJobMasterId && m.CheckListJobGroupId == data.checkListJobGroupId).FirstOrDefault();
// if (res == null)
// {
// try
// {
// CheckListJobWrtoperator item = new CheckListJobWrtoperator();
// item.CheckListJobMasterId = Convert.ToInt32(data.checkListJobMasterId);
// item.CheckListJobGroupId = data.checkListJobGroupId;
// item.OperatorId = userId ;
// item.CheckListJobStartTime = DateTime.Now ;
// item.CheckListJobIsCompleted = false ;
// item.CheckListJobIsPartialCompleted = true ;
// item.IsAdminApproved = false ;
// item.IsJobRejected = false ;
// item.IsJobClosed = false ;
// item.IsActive = true;
// item.IsDeleted = false;
// item.CreatedBy = userId;
// item.CreatedOn = DateTime.Now;
// db.CheckListJobWrtoperator.Add(item);
// db.SaveChanges();
// obj.response = ResourceResponse.AddedSucessfully;
// obj.isStatus = true;
// obj.id = item.CheckListJobWrtoperatorId;
// }
// catch (Exception ex)
// {
// log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); }
// obj.response = ResourceResponse.ExceptionMessage;
// obj.isStatus = false;
// }
// }
// else
// {
// try
// {
// res.OperatorId = userId;
// res.IsAdminApproved = false;
// res.IsJobClosed = false;
// res.IsJobRejected = false;
// res.ModifiedBy = userId;
// res.ModifiedOn = DateTime.Now;
// db.SaveChanges();
// obj.response = ResourceResponse.UpdatedSucessfully;
// obj.isStatus = true;
// obj.id = res.CheckListJobWrtoperatorId;
// }
// catch (Exception ex)
// {
// log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); }
// obj.response = ResourceResponse.ExceptionMessage;
// obj.isStatus = false;
// }
// }
// }
// catch (Exception ex)
// {
// log.Error(ex); if (ex.InnerException != null) { log.Error(ex.InnerException.ToString()); }
// obj.response = ResourceResponse.ExceptionMessage;
// obj.isStatus = false;
// }
// return obj;
//}
public CommonResponseWithIds AddAndEditCheckListJobOperator(CheckListJobOperatorCustom data, long userId = 0)
{
CommonResponseWithIds obj = new CommonResponseWithIds();
try
{
var res = db.CheckListJobWrtoperator.Where(m => m.CheckListJobMasterId == data.checkListJobMasterId && m.CheckListJobGroupId == data.checkListJobGroupId).FirstOrDefault();
if (res == null)
{
try
{
CheckListJobWrtoperator item = new CheckListJobWrtoperator();
item.CheckListJobMasterId = Convert.ToInt64(data.checkListJobMasterId);
item.CheckListJobGroupId = data.checkListJobGroupId;
item.OperatorId = userId;
item.CheckListJobStartTime = DateTime.Now;
item.CheckListJobIsCompleted = false;
item.CheckListJobIsPartialCompleted = true;
item.IsAdminApproved = false;
item.IsJobRejected = false;
item.IsJobClosed = false;
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.CheckListJobWrtoperator.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
obj.id = item.CheckListJobWrtoperatorId;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.OperatorId = userId;
//if (res.IsAdminApproved == true)
//{
// res.IsAdminApproved = true;
//}
//else
//{
// res.IsAdminApproved = false;
//}
//if (res.IsJobClosed == true)
//{
// res.IsJobClosed = true;
//}
//else
//{
// res.IsJobClosed = false;
//}
if (res.IsJobRejected == true)
{
res.IsJobRejected = true;
}
else
{
res.IsJobRejected = false;
}
res.IsAdminApproved = false;
res.IsJobClosed = false;
// res.IsJobRejected = false;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
obj.id = res.CheckListJobWrtoperatorId;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// ChangeCheckListAndJobStepNumberOfPreviousItem
/// </summary>
/// <param name="checkListMasterId"></param>
/// <param name="checkListGroupId"></param>
/// <param name="activityType"></param>
/// <param name="major"></param>
/// <returns></returns>
public int ChangeCheckListAndJobStepNumberOfPreviousItem(long?checkListMasterId, long?checkListGroupId, string activityType, string major)
{
int stepNumber = 0;
try
{
if (major == "CheckList")
{
switch (activityType)
{
case "Activity":
var checkListActivityMaster = db.CheckListActivityMaster.Where(m => m.CheckListMasterId == checkListMasterId && m.CheckListGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList();
int i = 1;
foreach (var item in checkListActivityMaster)
{
item.CheckListStepNumber = i;
db.SaveChanges();
i++;
}
stepNumber = checkListActivityMaster.Count;
break;
case "Advance":
var checkListAdvanceMaster = db.CheckListAdvanceMaster.Where(m => m.CheckListMasterId == checkListMasterId && m.CheckListGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList();
int j = 1;
foreach (var item in checkListAdvanceMaster)
{
item.CheckListStepNumber = j;
db.SaveChanges();
j++;
}
stepNumber = checkListAdvanceMaster.Count;
break;
case "LOTOTO":
var checkListLototomaster = db.CheckListLototomaster.Where(m => m.CheckListMasterId == checkListMasterId && m.CheckListGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList();
int k = 1;
foreach (var item in checkListLototomaster)
{
item.CheckListLockStepNumber = k;
db.SaveChanges();
k++;
}
stepNumber = checkListLototomaster.Count;
break;
default: break;
}
}
else
{
switch (activityType)
{
case "Activity":
var checkListActivityMaster = db.CheckListJobActivityMaster.Where(m => m.CheckListJobMasterId == checkListMasterId && m.CheckListJobGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList();
int i = 1;
foreach (var item in checkListActivityMaster)
{
item.CheckListJobStepNumber = i;
db.SaveChanges();
i++;
}
stepNumber = checkListActivityMaster.Count;
break;
case "Advance":
var checkListAdvanceMaster = db.CheckListJobAdvanceMaster.Where(m => m.CheckListJobMasterId == checkListMasterId && m.CheckListJobGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList();
int j = 1;
foreach (var item in checkListAdvanceMaster)
{
item.CheckListJobStepNumber = j;
db.SaveChanges();
j++;
}
stepNumber = checkListAdvanceMaster.Count;
break;
case "LOTOTO":
var checkListLototomaster = db.CheckListJobLototomaster.Where(m => m.CheckListJobMasterId == checkListMasterId && m.CheckListJobGroupId == checkListGroupId && m.IsDeleted == false).OrderBy(m => m.CreatedOn).ToList();
int k = 1;
foreach (var item in checkListLototomaster)
{
item.CheckListJobLockStepNumber = k;
db.SaveChanges();
k++;
}
stepNumber = checkListLototomaster.Count;
break;
default: break;
}
}
}
catch (Exception ex)
{ }
return(stepNumber);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditCheckListJobActivityOperator(CheckListJobActivityOperatorCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
try
{
var res = db.CheckListJobActivityOperator.Where(m => m.CheckListJobOperatorId == data.checkListJobOperatorId && m.CheckListJobActivityId == data.checkListJobActivityId).FirstOrDefault();
if (res == null)
{
try
{
CheckListJobActivityOperator item = new CheckListJobActivityOperator();
item.CheckListJobOperatorId = data.checkListJobOperatorId;
item.OperatorId = userId;
item.OperatorScannedBarcodeNumber = data.operatorScannedBarcodeNumber;
item.BarcodeAssetId = data.barcodeAssetId;
item.OperatorUpoadedDocumentId = data.operatorUpoadedDocumentId;
item.OperatorRemark = data.operatorRemark;
item.CheckListJobActivityId = data.checkListJobActivityId;
item.IsActive = true;
item.IsDeleted = false;
item.IsJobRejected = false;
item.IsAdminApproved = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.CheckListJobActivityOperator.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.OperatorId = userId;
res.OperatorScannedBarcodeNumber = data.operatorScannedBarcodeNumber;
res.BarcodeAssetId = data.barcodeAssetId;
res.OperatorUpoadedDocumentId = data.operatorUpoadedDocumentId;
res.OperatorRemark = data.operatorRemark;
res.CheckListJobActivityId = data.checkListJobActivityId;
res.ActivityEndTime = DateTime.Now;
res.IsAdminApproved = false;
res.IsJobRejected = false;
res.JobRejectedReason = "";
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponseWithIds AddAndEditCheckList(CheckListCustom data, long userId)
{
CommonResponseWithIds obj = new CommonResponseWithIds();
try
{
var res = db.CheckListMaster.Where(m => m.CheckListName == data.checkListName && m.CheckListVersion == data.checkListVersion && m.IsDeleted == false && m.IsActive == true).FirstOrDefault();
if (res == null)
{
try
{
CheckListMaster item = new CheckListMaster();
item.CheckListName = data.checkListName.Trim();
item.CheckListDescription = data.checkListDescription;
item.CheckListOwner = data.checkListOwner;
item.CheckListVersion = data.checkListVersion;
item.CheckListCategoryId = data.checkListCategoryId;
item.CheckListTypeId = data.checkListTypeId;
item.CheckListGroup = data.checkListGroup;
//Mani
item.EstimatedEndTime = data.estimatedTime;
//Mani
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.CheckListMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
obj.id = item.CheckListId;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.CheckListName = data.checkListName;
res.CheckListDescription = data.checkListDescription;
res.CheckListOwner = data.checkListOwner;
res.CheckListVersion = data.checkListVersion;
res.CheckListCategoryId = data.checkListCategoryId;
res.CheckListTypeId = data.checkListTypeId;
res.CheckListGroup = data.checkListGroup;
res.EstimatedEndTime = data.estimatedTime;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
obj.id = data.checkListId;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponseWithIds AddAndEditAsset(AssetCustom data, long userId = 0)
{
CommonResponseWithIds obj = new CommonResponseWithIds();
try
{
var res = db.AssetMaster.Where(m => m.AssetId == data.assetId).FirstOrDefault();
if (res == null)
{
try
{
AssetMaster item = new AssetMaster();
item.AssetName = data.assetName;
item.AssetDescription = data.assetDescription;
item.AssetDocumentUploadedId = data.assetDocumentUploadedId;
item.BarcodeAllocatedNumber = data.barcodeAllocatedNumber;
item.LineNumber = data.lineNumber;
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.AssetMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
obj.id = item.AssetId;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.AssetName = data.assetName;
res.AssetDescription = data.assetDescription;
res.AssetDocumentUploadedId = data.assetDocumentUploadedId;
res.BarcodeAllocatedNumber = data.barcodeAllocatedNumber;
res.LineNumber = data.lineNumber;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.id = res.AssetId;
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add And Edit Document Uploader
/// </summary>
/// <param name="documentDetails"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponseWithIdsDoc AddAndEditDocumentUploader(DocumentUplodedMasterCustom documentDetails, long userId)
{
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.DocumentUplodedMaster.Where(m => m.DocumentUploaderId == documentDetails.documentUploaderId && m.IsDeleted == false && m.IsActive == true).FirstOrDefault();
if (dbItem == null)
{
#region insert item into DB
DocumentUplodedMaster documentUplodedMaster = new DocumentUplodedMaster();
documentUplodedMaster.DocumentName = documentDetails.Image.FileName;
documentUplodedMaster.DocumentMasterId = documentDetails.documentMasterId;
documentUplodedMaster.FileName = fileName;
documentUplodedMaster.FilePath = path;
documentUplodedMaster.CreatedOn = DateTime.Now;
documentUplodedMaster.CreatedBy = 0;
documentUplodedMaster.IsDeleted = false;
documentUplodedMaster.IsActive = true;
documentUplodedMaster.DocumentUploadedFor = documentDetails.DocumentUploadedFor;
db.DocumentUplodedMaster.Add(documentUplodedMaster);
db.SaveChanges();
response.id = documentUplodedMaster.DocumentUploaderId;
var doc = appSettings.ImageUrl +
(from wfd in db.DocumentUplodedMaster
where wfd.IsDeleted == false && wfd.DocumentUploaderId == documentUplodedMaster.DocumentUploaderId
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.DocumentUploadedFor = 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.DocumentUplodedMaster
where wfd.IsDeleted == false && wfd.DocumentUploaderId == dbItem.DocumentUploaderId
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 and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditTargetOverAll(TargetOverAllCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
try
{
DateTime st = DateTime.Now;
DateTime et = DateTime.Now;
#region ST and ET
try
{
st = Convert.ToDateTime(data.targetStartTime);
}
catch (Exception ex)
{
}
try
{
et = Convert.ToDateTime(data.targetEndTime);
}
catch (Exception ex)
{
}
#endregion
var res = db.TargetOverall.Where(m => m.TargetId == data.targetId).FirstOrDefault();
if (res == null)
{
try
{
TargetOverall item = new TargetOverall();
item.TargetYearName = data.targetYearName;
item.TargetValue = data.targetValue;
item.TargetStartTime = st;
item.TargetEndTime = et;
item.IsActive = true;
item.IsDeleted = false;
db.TargetOverall.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.TargetYearName = data.targetYearName;
res.TargetValue = data.targetValue;
res.TargetStartTime = st;
res.TargetEndTime = et;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditCheckListJobLOTOTOOperator(CheckListJobLOTOTOOperatorCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
try
{
var checklWRT = db.CheckListJobWrtoperator.Where(m => m.CheckListJobWrtoperatorId == data.checkListJobOperatorId).FirstOrDefault();
var res = db.CheckListJobLototooperator.Where(m => m.checkListJobId == checklWRT.CheckListJobMasterId && m.checkListJobGroupId == checklWRT.CheckListJobGroupId && m.CheckListJobLototoid == data.checkListJobLOTOTOId).FirstOrDefault();
if (res == null)
{
try
{
CheckListJobLototooperator item = new CheckListJobLototooperator();
item.CheckListJobOperatorId = data.checkListJobOperatorId;
item.OperatorId = userId;
item.OverAllRemark = data.overAllRemark;
// item.LockOutDoneByOperator = data.lockOutDoneByOperator;
// item.LockOutRemark = data.lockOutRemark;
// item.TagOutDoneByOperator = data.tagOutDoneByOperator;
// item.TagOutRemark = data.tagOutRemark;
item.TryOutDoneByOperator = data.tryOutDoneByOperator;
item.CheckListJobLototoid = data.checkListJobLOTOTOId;
item.TryOutRemark = data.tryOutRemark;
item.IsJobRejected = false;
item.IsActive = true;
item.IsDeleted = false;
item.IsAdminApproved = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.CheckListJobLototooperator.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.CheckListJobOperatorId = data.checkListJobOperatorId;
res.OperatorId = userId;
res.OverAllRemark = data.overAllRemark;
//res.LockOutDoneByOperator = data.lockOutDoneByOperator;
//res.LockOutRemark = data.lockOutRemark;
//res.TagOutDoneByOperator = data.tagOutDoneByOperator;
//res.TagOutRemark = data.tagOutRemark;
res.TryOutDoneByOperator = data.tryOutDoneByOperator;
res.CheckListJobLototoid = data.checkListJobLOTOTOId;
res.TryOutRemark = data.tryOutRemark;
res.IsAdminApproved = false;
res.IsJobRejected = false;
res.JobRejectedReason = "";
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
/// <summary>
/// Add and Edit HelpContent
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditHelpContent(HelpContentCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
try
{
var res = db.HelpContentMaster.Where(m => m.HelpContentId == data.helpContentId).FirstOrDefault();
if (res == null)
{
try
{
HelpContentMaster item = new HelpContentMaster();
item.HelpContentShortName = data.helpContentShortName;
item.HelpContentDescription = data.helpContentDescription;
item.InstructionLink = data.instructionLink;
item.VisbleToRoleId = data.visbleToRoleId;
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.HelpContentMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.HelpContentShortName = data.helpContentShortName;
res.HelpContentDescription = data.helpContentDescription;
res.InstructionLink = data.instructionLink;
res.VisbleToRoleId = data.visbleToRoleId;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}