public int AddNewManageAsset(ManageAssetsModels _manageAssetsModels)
{
int result = 0;
if (_manageAssetsModels.Assets_Id > 0)
{
using (opsdbEntities _dbContext = new opsdbEntities())
{
var q = _dbContext.OPS_ManageAssets.FirstOrDefault(x => x.AssetType == _manageAssetsModels.AssetType);
if (q == null)
{
var query = _dbContext.OPS_ManageAssets.Find(_manageAssetsModels.Assets_Id);
if (query != null)
{
query.AssetType = _manageAssetsModels.AssetType;
query.ModifiedBy = HttpContext.Current.User.Identity.Name;
query.ModifiedDate = DateTime.Now;
_dbContext.SaveChanges();
result = 1;
}
}
else
{
result = -2;
}
}
}
else
{
using (opsdbEntities _dbContext = new opsdbEntities())
{
var q = _dbContext.OPS_ManageAssets.FirstOrDefault(x => x.AssetType == _manageAssetsModels.AssetType);
if (q == null)
{
OPS_ManageAssets _obj = new OPS_ManageAssets();
_obj.AssetType = _manageAssetsModels.AssetType;
_obj.CreatedBy = HttpContext.Current.User.Identity.Name;
_obj.CreatedDate = DateTime.Now;
_dbContext.OPS_ManageAssets.Add(_obj);
_dbContext.SaveChanges();
result = 1;
}
else
{
result = -2;
}
}
}
return(result);
}
public int AddNewDataEntry()
{
string[] shiftEndTime = ConfigurationManager.AppSettings["shiftEndTime"].Split(':');
var shiftStartTime = checkShiftTime();
var times = new List <string>();
DateTime today = DateTime.Today.AddHours(shiftStartTime);
DateTime tomorrow = today.AddHours(Convert.ToInt32(shiftEndTime[0])).AddMinutes(Convert.ToInt32(shiftEndTime[1])).AddSeconds(Convert.ToInt32(shiftEndTime[2]));
for (var i = today; i < tomorrow; i = i.AddHours(1))
{
times.Add(i.ToString("hh:mm tt"));
//times.Add(i.ToString("HH:mm:ss"));
}
//TimeSpan start = new TimeSpan(today.Hour, today.Minute, today.Second);
//TimeSpan end = new TimeSpan(tomorrow.Hour, tomorrow.Minute, tomorrow.Second);
//TimeSpan now = DateTime.Now.TimeOfDay;
//if ((now > start) && (now < end))
//{
// //match found
//}
if (times.Count > 0)
{
using (opsdbEntities _dbContext = new opsdbEntities())
{
foreach (var item in times)
{
Guid id = Guid.NewGuid();
OPS_DataEntry _obj = new OPS_DataEntry();
_obj.ShiftTime = item;
_obj.CreatedBy = HttpContext.Current.User.Identity.Name;
_obj.CreatedDate = DateTime.Now;
_obj.ManageShifts_Id = GetManageShifts(shiftStartTime).ManageShifts_Id;
_obj.Unique_ID = id.ToString();
_dbContext.OPS_DataEntry.Add(_obj);
}
_dbContext.SaveChanges();
}
}
return(1);
}
public int DeleteManageDowntime(int id)
{
int result = 0;
using (opsdbEntities _dbContext = new opsdbEntities())
{
var query = _dbContext.OPS_ManageDowntime.Find(id);
if (query != null)
{
query.IsDeleted = true;
query.ModifiedBy = HttpContext.Current.User.Identity.Name;
query.ModifiedDate = DateTime.Now;
_dbContext.SaveChanges();
result = 1;
}
}
return(result);
}
public int DeleteManageAssets(int id, string name)
{
int result = 0;
using (opsdbEntities _dbContext = new opsdbEntities())
{
var q = _dbContext.OPS_ManageDowntime.FirstOrDefault(x => x.Assets_Id == id);
if (q == null)
{
var query = _dbContext.OPS_ManageAssets.Find(id);
if (query != null)
{
query.IsDeleted = true;
query.ModifiedBy = HttpContext.Current.User.Identity.Name;
query.ModifiedDate = DateTime.Now;
_dbContext.SaveChanges();
result = 1;
}
}
}
return(result);
}
public int AddNewManageDowntime(ManageDowntimeModels _manageDowntimeModels)
{
int result = 0;
var ToDate = !string.IsNullOrWhiteSpace(_manageDowntimeModels.To) ? Convert.ToDateTime(DateTime.ParseExact(_manageDowntimeModels.To, "dd/MM/yyyy hh:mm tt", CultureInfo.InvariantCulture)
.ToString("MM/dd/yyyy hh:mm tt", CultureInfo.InvariantCulture)) : DateTime.Now;
var FromDate = !string.IsNullOrWhiteSpace(_manageDowntimeModels.From) ? Convert.ToDateTime(DateTime.ParseExact(_manageDowntimeModels.From, "dd/MM/yyyy hh:mm tt", CultureInfo.InvariantCulture)
.ToString("MM/dd/yyyy hh:mm tt", CultureInfo.InvariantCulture)) : DateTime.Now;
var assetss = GetAssetType(Convert.ToInt32(_manageDowntimeModels.Assets));
if (_manageDowntimeModels.ManageDowntime_Id > 0)
{
using (opsdbEntities _dbContext = new opsdbEntities())
{
var query = _dbContext.OPS_ManageDowntime.Find(_manageDowntimeModels.ManageDowntime_Id);
if (query != null)
{
//TimeSpan duration = DateTime.Parse(_manageDowntimeModels.To).Subtract(DateTime.Parse(_manageDowntimeModels.From));
TimeSpan duration = ToDate.Subtract(FromDate);
query.Assets = assetss;
query.Assets_Id = Convert.ToInt32(_manageDowntimeModels.Assets);
query.Status = _manageDowntimeModels.Status;
query.From = _manageDowntimeModels.From;
query.To = _manageDowntimeModels.To;
query.Reason = _manageDowntimeModels.Reason;
query.Time_Diff = Convert.ToInt32(duration.TotalSeconds);
query.ModifiedBy = HttpContext.Current.User.Identity.Name;
query.ModifiedDate = DateTime.Now;
query.FromDate = FromDate;
query.ToDate = ToDate;
_dbContext.SaveChanges();
result = 1;
}
}
}
else
{
using (opsdbEntities _dbContext = new opsdbEntities())
{
OPS_ManageDowntime _obj = new OPS_ManageDowntime();
TimeSpan duration = ToDate.Subtract(FromDate);
//TimeSpan duration = DateTime.Parse(_manageDowntimeModels.To).Subtract(DateTime.Parse(_manageDowntimeModels.From));
//var ts = TimeSpan.FromSeconds(duration.TotalSeconds);
//string dtf = string.Format("{0:D2} : {1:D2}",ts.Hours, ts.Minutes);
_obj.Assets = assetss;
_obj.Assets_Id = Convert.ToInt32(_manageDowntimeModels.Assets);
_obj.Status = _manageDowntimeModels.Status;
_obj.From = _manageDowntimeModels.From;
_obj.To = _manageDowntimeModels.To;
_obj.Reason = _manageDowntimeModels.Reason;
_obj.Time_Diff = Convert.ToInt32(duration.TotalSeconds);
_obj.CreatedBy = HttpContext.Current.User.Identity.Name;
_obj.CreatedDate = DateTime.Now;
_obj.FromDate = FromDate;
_obj.ToDate = ToDate;
_dbContext.OPS_ManageDowntime.Add(_obj);
_dbContext.SaveChanges();
result = 1;
}
}
return(result);
}
public int EditManageDataEntry(OPS_DataEntry _obj)
{
int result = 0;
using (opsdbEntities _dbContext = new opsdbEntities())
{
var query = _dbContext.OPS_DataEntry.FirstOrDefault(x => x.Unique_ID == _obj.Unique_ID);
if (_obj.IsDeleted == true)
{
var q = _dbContext.OPS_DeletedDataEntry.FirstOrDefault(x => x.Unique_ID == _obj.Unique_ID);
if (q != null)
{
_dbContext.OPS_DeletedDataEntry.Remove(q);
_dbContext.SaveChanges();
}
OPS_DeletedDataEntry obj = new OPS_DeletedDataEntry();
obj.DataEntry_Id = query.DataEntry_Id;
obj.CV01 = query.CV01;
obj.Rougher = query.Rougher;
obj.HMC = query.HMC;
obj.FlocUse = query.FlocUse;
obj.FlocBatch = query.FlocBatch;
obj.Slime = query.Slime;
obj.SlimePer = query.SlimePer;
obj.Tails1 = query.Tails1;
obj.Tails2 = query.Tails2;
obj.Reason = query.Reason;
obj.IsDeleted = _obj.IsDeleted;
obj.CreatedBy = query.CreatedBy;
obj.CreatedDate = query.CreatedDate;
obj.ModifiedBy = HttpContext.Current.User.Identity.Name;
obj.ModifiedDate = DateTime.Now;
obj.ManageShifts_Id = query.ManageShifts_Id;
obj.AD_Id = query.AD_Id;
obj.Unique_ID = _obj.Unique_ID;
obj.ShiftTime = query.ShiftTime;
_dbContext.OPS_DeletedDataEntry.Add(obj);
_dbContext.SaveChanges();
}
if (query != null)
{
query.CV01 = _obj.CV01;
query.Rougher = _obj.Rougher;
query.HMC = _obj.HMC;
query.FlocUse = _obj.FlocUse;
query.FlocBatch = _obj.FlocBatch;
query.Slime = _obj.Slime;
query.SlimePer = _obj.SlimePer;
query.Tails1 = _obj.Tails1;
query.Tails2 = _obj.Tails2;
query.Reason = _obj.Reason;
query.IsDeleted = _obj.IsDeleted;
query.ModifiedBy = HttpContext.Current.User.Identity.Name;
query.ModifiedDate = DateTime.Now;
result = 1;
_dbContext.SaveChanges();
}
}
return(result);
}