public static Guid InsertOrUpdate(Guid MetricID, DateTime Date, Guid OrgLocationID, bool IsFilesAttached, bool Approve, Guid?SelectedUoMID, string OldValue, string Value, bool?OldApproved, bool?Approved, Guid?UserId, string Notes, string CustomMetricAlias, string CustomMetricCode)
{
using (LinqMicajahDataContext dc = new LinqMicajahDataContext())
{
Metric metric =
(from m in dc.Metric
where
m.MetricID == MetricID &&
m.InstanceId == LinqMicajahDataContext.InstanceId &&
m.Status == true
select m).FirstOrNull();
Guid _ActualValueID = Guid.Empty;
if (metric != null)
{
MetricValue metricValue =
(from mv in dc.MetricValue
where
mv.MetricID == MetricID &&
mv.InstanceId == LinqMicajahDataContext.InstanceId &&
mv.Status == true &&
mv.Date == Date &&
mv.FrequencyID == metric.FrequencyID &&
mv.OrgLocationID == OrgLocationID
select mv).FirstOrNull();
MetricOrgLocationUoM MOUoM =
(from muom in dc.MetricOrgLocationUoM
where
muom.MetricID == MetricID &&
muom.InstanceId == LinqMicajahDataContext.InstanceId &&
muom.OrgLocationID == OrgLocationID
select muom).FirstOrNull();
if (MOUoM == null)
{
Bll.MetricOrgLocationUoM muom = new Bll.MetricOrgLocationUoM();
muom.MetricID = MetricID;
muom.OrgLocationID = OrgLocationID;
muom.InputUnitOfMeasureID = SelectedUoMID;
dc.MetricOrgLocationUoM.InsertOnSubmit(muom);
}
else
if (SelectedUoMID != MOUoM.InputUnitOfMeasureID)
{
MOUoM.InputUnitOfMeasureID = SelectedUoMID; // change org location uom
}
if (CustomMetricAlias != null && CustomMetricCode != null)
{
MetricOrgLocationName MOName =
(from mname in dc.MetricOrgLocationName
where
mname.MetricID == MetricID &&
mname.InstanceId == LinqMicajahDataContext.InstanceId &&
mname.OrgLocationID == OrgLocationID
select mname).FirstOrNull();
if (MOName == null)
{
Bll.MetricOrgLocationName moname = new Bll.MetricOrgLocationName();
moname.MetricID = MetricID;
moname.OrgLocationID = OrgLocationID;
moname.Alias = CustomMetricAlias;
moname.Code = CustomMetricCode;
dc.MetricOrgLocationName.InsertOnSubmit(moname);
}
else
{ // update org location specific metric names
MOName.Alias = CustomMetricAlias;
MOName.Code = CustomMetricCode;
}
}
dc.SubmitChanges();
string ConvertedValue = Value;
if (metric.UnitOfMeasureID != SelectedUoMID && metric.MetricDataTypeID == 1 && SelectedUoMID != null && metric.UnitOfMeasureID != null)
{
ConvertedValue = Mc_UnitsOfMeasure.ConvertValue(Value, (Guid)SelectedUoMID, (Guid)metric.UnitOfMeasureID);
}
if (metricValue == null)
{
Bll.MetricValue mv = new Bll.MetricValue();
mv.MetricValueID = Guid.NewGuid();
mv.MetricID = MetricID;
mv.FrequencyID = metric.FrequencyID;
mv.Date = Date;
mv.OrgLocationID = OrgLocationID;
mv.InputUnitOfMeasureID = SelectedUoMID;
mv.UnitOfMeasureID = metric.UnitOfMeasureID;
mv.MetricDataTypeID = metric.MetricDataTypeID;
mv.Value = Value;
mv.ConvertedValue = ConvertedValue;
mv.InputUserId = UserId;
mv.Approved = false;
mv.ReviewUpdated = false;
mv.ApproveUserId = null;
mv.Notes = Notes;
mv.FilesAttached = IsFilesAttached;
mv.IsCalc = true;
mv.InProcess = false;
dc.MetricValue.InsertOnSubmit(mv);
dc.SubmitChanges();
_ActualValueID = mv.MetricValueID;
}
else
{
metricValue.MetricDataTypeID = metric.MetricDataTypeID;
metricValue.InputUnitOfMeasureID = SelectedUoMID;
metricValue.UnitOfMeasureID = metric.UnitOfMeasureID;
metricValue.Value = Value;
metricValue.ConvertedValue = ConvertedValue;
metricValue.Approved = Approved;
metricValue.ReviewUpdated = (Approve) ? false : (OldApproved == null && Approved == null);
if (Approve)
{
if (OldApproved != Approved)
{
metricValue.ApproveUserId = UserId;
}
if (OldValue != Value)
{
metricValue.InputUserId = UserId;
}
}
else
{
metricValue.InputUserId = UserId;
}
metricValue.Notes = Notes;
metricValue.FilesAttached = IsFilesAttached;
metricValue.IsCalc = true;
dc.SubmitChanges();
_ActualValueID = metricValue.MetricValueID;
}
}
return(_ActualValueID);
}
}
private void SaveBulkValues()
{
int i = 0;
LastFrequencyMetric = GetData();
List <Bll.MetricValue.Extend> NewValues = new List <MetricValue.Extend>();
List <Bll.MetricValue.Extend> OldValues = new List <MetricValue.Extend>();
List <Bll.MetricOrgLocationUoM> MetricOrgLocationUoMList = new List <Bll.MetricOrgLocationUoM>();
foreach (RepeaterItem ri in rMetric.Items)
{
MetricOrgValue mov = LastFrequencyMetric.Metrics[i];
DateTime iTime = DateTime.Now;
DropDownList ddlInputUnitOfMeasure = (DropDownList)ri.FindControl("ddlInputUnitOfMeasure");
HiddenField hfUoM = (HiddenField)ri.FindControl("hfUoM");
HiddenField hfMetric = (HiddenField)ri.FindControl("hfMetric");
HiddenField hfOrgLocation = (HiddenField)ri.FindControl("hfOrgLocation");
Repeater r = (Repeater)ri.FindControl("rMericValue");
Guid?ActualUoMID = null;
if (ddlInputUnitOfMeasure.Visible)
{
if (!String.IsNullOrEmpty(ddlInputUnitOfMeasure.SelectedValue))
{
ActualUoMID = new Guid(ddlInputUnitOfMeasure.SelectedValue);
}
}
else
{
if (!String.IsNullOrEmpty(hfUoM.Value))
{
ActualUoMID = new Guid(hfUoM.Value);
}
}
Guid oMetricID = new Guid(hfMetric.Value);
Guid oOrgLocationID = new Guid(hfOrgLocation.Value);
Bll.MetricOrgLocationUoM muom = new Bll.MetricOrgLocationUoM();
muom.MetricID = oMetricID;
muom.OrgLocationID = oOrgLocationID;
muom.InputUnitOfMeasureID = ActualUoMID;
MetricOrgLocationUoMList.Add(muom);
int j = 0;
foreach (RepeaterItem rri in r.Items)
{
DateTime jTime = DateTime.Now;
HiddenField hfDate = (HiddenField)rri.FindControl("hfDate");
DateTime oDate = DateTime.Parse(hfDate.Value);
Telerik.Web.UI.RadNumericTextBox rntValue = (Telerik.Web.UI.RadNumericTextBox)rri.FindControl("rntValue");
System.Web.UI.WebControls.TextBox tbValue = (System.Web.UI.WebControls.TextBox)rri.FindControl("tbValue");
System.Web.UI.WebControls.CheckBox chbValue = (System.Web.UI.WebControls.CheckBox)rri.FindControl("chbValue");
Telerik.Web.UI.RadDatePicker rdpDateValue = (Telerik.Web.UI.RadDatePicker)rri.FindControl("rdpDateValue");
System.Web.UI.WebControls.DropDownList ddlApprovalStatus = (System.Web.UI.WebControls.DropDownList)rri.FindControl("ddlApprovalStatus");
Bll.MetricValue.Extend OldMetricValue = mov.MetricValues[j];
string Value = String.Empty;
if (rntValue.Visible)
{
Value = rntValue.Value.ToString();
}
else
if (tbValue.Visible)
{
Value = tbValue.Text;
}
else
if (chbValue.Visible)
{
Value = chbValue.Checked ? bool.TrueString : bool.FalseString;
}
else
if (rdpDateValue.Visible)
{
Value = rdpDateValue.SelectedDate.ToString();
}
bool?Approved = OldMetricValue.Approved;
if (DataMode == Mode.Approve)
{
switch (ddlApprovalStatus.SelectedValue)
{
case "":
Approved = null;
break;
case "True":
Approved = true;
break;
case "False":
default:
Approved = false;
break;
}
}
if (
(
(
!String.IsNullOrEmpty(Value)
||
(OldMetricValue.MetricValueID != Guid.Empty && String.IsNullOrEmpty(Value))
) &&
Value != OldMetricValue.Value
)
||
(DataMode == Mode.Approve && Approved != OldMetricValue.Approved))
{
MetricValue.Extend nv = new MetricValue.Extend();
nv.MetricID = oMetricID;
nv.Date = oDate;
nv.OrgLocationID = oOrgLocationID;
nv.InputUnitOfMeasureID = ActualUoMID;
nv.Value = Value;
nv.Approved = Approved;
// additional fields
nv.Period = Frequency.GetPeriodName(oDate, FrequencyID);
nv.MetricName = mov.Name;
nv.OrgLocationFullName = mov.OrgLocationFullName;
nv.Notes = OldMetricValue.Notes;
nv.ValueInputUnitOfMeasureName = mov.OrgLocationUnitOfMeasureName;
NewValues.Add(nv);
OldValues.Add(OldMetricValue);
}
LogTime += " value " + j.ToString() + " time " + ((TimeSpan)(DateTime.Now - jTime)).TotalMilliseconds;
j++;
}
LogTime += "Row " + i.ToString() + " time " + ((TimeSpan)(DateTime.Now - iTime)).TotalMilliseconds + "<br />";
i++;
}
Bll.MetricValue.SaveBulkValues(MetricOrgLocationUoMList, NewValues, OldValues, Micajah.Common.Security.UserContext.Current, DataMode == Mode.Input);
}
public static void SaveBulkValues(List <Bll.MetricOrgLocationUoM> MetricOrgLocationUoMList, List <Bll.MetricValue.Extend> NewValues, List <Bll.MetricValue.Extend> OldValues, Micajah.Common.Security.UserContext CurrentUser, bool InputMode)
{
using (LinqMicajahDataContext dc = new LinqMicajahDataContext())
{
foreach (MetricOrgLocationUoM uom in MetricOrgLocationUoMList)
{
MetricOrgLocationUoM MOUoM =
(from muom in dc.MetricOrgLocationUoM
where
muom.MetricID == uom.MetricID &&
muom.InstanceId == LinqMicajahDataContext.InstanceId &&
muom.OrgLocationID == uom.OrgLocationID
select muom).FirstOrNull();
if (MOUoM == null)
{
Bll.MetricOrgLocationUoM muom = new Bll.MetricOrgLocationUoM();
muom.MetricID = uom.MetricID;
muom.OrgLocationID = uom.OrgLocationID;
muom.InputUnitOfMeasureID = uom.InputUnitOfMeasureID;
dc.MetricOrgLocationUoM.InsertOnSubmit(muom);
}
else
if (uom.InputUnitOfMeasureID != MOUoM.InputUnitOfMeasureID)
{
MOUoM.InputUnitOfMeasureID = uom.InputUnitOfMeasureID;
}
}
dc.SubmitChanges();
Metric metric = null;
for (int i = 0; i < NewValues.Count; i++)
{
MetricValue.Extend NewValue = NewValues[i];
MetricValue.Extend OldValue = OldValues[i];
bool UpdateMetric = false;
if (metric == null)
{
UpdateMetric = true;
}
else if (metric.MetricID != NewValue.MetricID)
{
UpdateMetric = true;
}
if (UpdateMetric)
{
metric =
(from m in dc.Metric
where
m.MetricID == NewValue.MetricID &&
m.InstanceId == LinqMicajahDataContext.InstanceId &&
m.Status == true
select m).FirstOrNull();
}
if (metric != null)
{
MetricValue metricValue =
(from mv in dc.MetricValue
where
mv.MetricID == NewValue.MetricID &&
mv.InstanceId == LinqMicajahDataContext.InstanceId &&
mv.Status == true &&
mv.Date == NewValue.Date &&
mv.FrequencyID == metric.FrequencyID &&
mv.OrgLocationID == NewValue.OrgLocationID
select mv).FirstOrNull();
string ConvertedValue = NewValue.Value;
if (metric.UnitOfMeasureID != NewValue.InputUnitOfMeasureID && metric.MetricDataTypeID == 1 && NewValue.InputUnitOfMeasureID != null && metric.UnitOfMeasureID != null)
{
ConvertedValue = Mc_UnitsOfMeasure.ConvertValue(NewValue.Value, (Guid)NewValue.InputUnitOfMeasureID, (Guid)metric.UnitOfMeasureID);
}
if (metricValue == null)
{
Bll.MetricValue mv = new Bll.MetricValue();
mv.MetricValueID = NewValue.MetricValueID = Guid.NewGuid();
mv.FrequencyID = metric.FrequencyID;
mv.UnitOfMeasureID = metric.UnitOfMeasureID;
mv.MetricDataTypeID = metric.MetricDataTypeID;
mv.ConvertedValue = ConvertedValue;
mv.InputUserId = CurrentUser.UserId;
mv.Approved = false;
mv.ReviewUpdated = false;
mv.ApproveUserId = null;
mv.Notes = null;
mv.FilesAttached = false;
mv.IsCalc = true;
mv.InProcess = false;
mv.MetricID = NewValue.MetricID;
mv.OrgLocationID = NewValue.OrgLocationID;
mv.Date = NewValue.Date;
mv.InputUnitOfMeasureID = NewValue.InputUnitOfMeasureID;
mv.Value = NewValue.Value;
dc.MetricValue.InsertOnSubmit(mv);
}
else
{
metricValue.MetricDataTypeID = metric.MetricDataTypeID;
metricValue.InputUnitOfMeasureID = NewValue.InputUnitOfMeasureID;
metricValue.UnitOfMeasureID = metric.UnitOfMeasureID;
metricValue.ConvertedValue = ConvertedValue;
metricValue.Approved = NewValue.Approved;
metricValue.ReviewUpdated = (!InputMode) ? false : (metricValue.Approved == null && NewValue.Approved == null);
if (!InputMode)
{
if (metricValue.Approved != NewValue.Approved)
{
metricValue.ApproveUserId = CurrentUser.UserId;
}
if (metricValue.Value != NewValue.Value)
{
metricValue.InputUserId = CurrentUser.UserId;
}
}
else
{
metricValue.InputUserId = CurrentUser.UserId;
}
metricValue.Value = NewValue.Value;
metricValue.IsCalc = true;
}
}
}
dc.SubmitChanges();
for (int i = 0; i < NewValues.Count; i++)
{
MetricValue.Extend NewValue = NewValues[i];
MetricValue.Extend OldValue = OldValues[i];
Bll.Mc_User.Extend mue = Bll.Mc_User.GetValueInputUser(dc, OldValue.MetricValueID);
// build mail to data collector if status or comment were changed
if ((!InputMode) && (OldValue.Approved != NewValue.Approved))
{
Bll.MetricValueChangeLog.LogChange(dc,
OldValue.MetricValueID == Guid.Empty ? NewValue.MetricValueID : OldValue.MetricValueID,
Bll.MetricValueChangeTypeEnum.StatusChanged,
OldValue.MetricValueID == Guid.Empty ? "Pending" : (OldValue.Approved == null ? "Under Review" : ((bool)OldValue.Approved ? "Approved" : "Pending")),
NewValue.Approved == null ? "Under Review" : ((bool)NewValue.Approved ? "Approved" : "Pending"),
Utils.Mail.BuildLogMessageBody(OldValue, NewValue, String.Empty, CurrentUser, mue, Bll.MetricValueChangeTypeEnum.StatusChanged));
if (NewValue.Approved == null && mue != null)
{
Utils.Mail.Send(mue.Email, mue.FullName, "MetricTrac - Value Status is changed", Utils.Mail.BuildEmailBody(OldValue, NewValue, String.Empty, CurrentUser));
}
}
// record in change log
if (OldValue.MetricValueID == Guid.Empty)
{
Bll.MetricValueChangeLog.LogChange(NewValue.MetricValueID,
MetricTrac.Bll.MetricValueChangeTypeEnum.ValueEntered,
String.Empty,
NewValue.Value,
Utils.Mail.BuildLogMessageBody(OldValue, NewValue, "Bulk Edit", CurrentUser, mue, MetricTrac.Bll.MetricValueChangeTypeEnum.ValueEntered));
}
else
if (OldValue.Value != NewValue.Value)
{
Bll.MetricValueChangeLog.LogChange(OldValue.MetricValueID,
MetricTrac.Bll.MetricValueChangeTypeEnum.ValueChanged,
OldValue.Value,
NewValue.Value,
Utils.Mail.BuildLogMessageBody(OldValue, NewValue, "Bulk Edit", CurrentUser, mue, MetricTrac.Bll.MetricValueChangeTypeEnum.ValueChanged));
}
}
dc.SubmitChanges();
}
}
