public ActionResult Create([Bind(Include = "CONFIG_COMMON_NAME,DIM_TYPE_GUID,DIM_COMMON_NAME,DIM_TABLE_SCHEMA,DIM_TABLE_NAME,DIM_LOAD_PROC_SCHEMA_RAW,DIM_LOAD_PROC_NAME_RAW,DIM_TABLE_CLEAN_SCHEMA,DIM_TABLE_CLEAN_NAME,DIM_PROC_UI_CLEAN_SCHEMA,DIM_PROC_UI_CLEAN_NAME,DIM_LOAD_PROC_CLEAN_SCHEMA,DIM_LOAD_PROC_CLEAN_NAME,DIM_VIEW_WHITELIST_SCHEMA,DIM_VIEW_WHITELIST_NAME,DIM_VIEW_RAW_SCHEMA,DIM_VIEW_RAW_NAME,DIM_VIEW_CLEAN_SCHEMA,DIM_VIEW_CLEAN_NAME,DIM_PROC_RAW_TABLE_CLEAN_ID_SCHEMA,DIM_PROC_RAW_TABLE_CLEAN_ID_NAME,DIM_FEATURE,DIM_TAXONOMY_PROC_SCHEMA,DIM_TAXONOMY_PROC_NAME,DIM_LOAD_PRE_PROC_SPROC_SCHEMA,DIM_LOAD_PRE_PROC_SPROC_NAME,DIM_LOAD_POST_PROC_SCHEMA,DIM_LOAD_POST_PROC_NAME,DIM_LOAD_PRE_PROC_CLEAN_SCHEMA,DIM_LOAD_PRE_PROC_CLEAN_NAME,DIM_LOAD_POST_PROC_CLEAN_SCHEMA,DIM_LOAD_POST_PROC_CLEAN_NAME,IS_STATIC,IS_AUTO_GENERATED")] string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, DIM dIM, string[] SelectedItems)
{
dIM.CONFIG_COMMON_NAME = Session["sClient"].ToString();
if (SelectedItems != null)
{
bool exists = BitwiseDictionaryChecker.IsExists(ref feature, SelectedItems, "DIM", db);
dIM.DIM_FEATURE = feature;
if (!exists)
{
ModelState.AddModelError(String.Empty, "Cannot create due to selection of invalid features.");
return RedirectToAction("Create", new { CONFIG_COMMON_NAME = Request["CONFIG_COMMON_NAME"].ToString(), DIM_COMMON_NAME = Request["DIM_COMMON_NAME"].ToString() });
}
}
if (ModelState.IsValid)
{
try
{
db.DIMs.Add(dIM);
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, ex.InnerException.InnerException.Message);
return RedirectToAction("Create", new { CONFIG_COMMON_NAME, DIM_COMMON_NAME });
}
db.SaveChanges();
return RedirectToAction("Index");
}
return View(dIM);
}
public ActionResult Edit(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME)
{
DIM dIM = db.DIMs.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME);
if (dIM == null)
{
return(HttpNotFound());
}
var features = db.BITWISE_DICTIONARY
.Where(f => f.BITWISE_GROUP == "DIM")
.ToList()
.Select(c => new
{
DIM_FEATURE = c.BITWISE_KEY,
DESCR = string.Format("{0} -- {1}", c.BITWISE_KEY, c.DESCR)
});
SelectList listSchemas = new SelectList(db.vSCHEMAS, "name", "name");
SelectList listTypes = new SelectList(db.DIM_TYPE, "DIM_TYPE_GUID", "DIM_TYPE_NAME");
MultiSelectList listFeatures = new MultiSelectList(features, "DIM_FEATURE", "DESCR", dIM.SelectedItems);
ViewBag.CONFIG_COMMON_NAME = new SelectList(db.CONFIGs, "CONFIG_COMMON_NAME", "CONFIG_COMMON_NAME", dIM.CONFIG_COMMON_NAME);
ViewBag.DIM_COMMON_NAME = new SelectList(db.DIMs, "DIM_COMMON_NAME", "DIM_COMMON_NAME", dIM.DIM_COMMON_NAME);
ViewBag.DIM_FEATURE = listFeatures;
ViewBag.DIM_TYPE_GUID = listTypes;
ViewBag.DIM_TABLE_SCHEMA = listSchemas;
return(View(dIM));
}
private void parseOBJEKT(SieDataItem di)
{
var dimNumber = di.GetString(0);
var number = di.GetString(1);
var name = di.GetString(2);
if (!DIM.ContainsKey(dimNumber))
{
DIM.Add(dimNumber, new SieDimension()
{
Number = dimNumber
});
}
var dim = DIM[dimNumber];
var obj = new SieObject()
{
Dimension = dim, Number = number, Name = name
};
if (!dim.Objects.ContainsKey(number))
{
dim.Objects.Add(number, obj);
}
else
{
dim.Objects[number] = obj;
}
}
public ActionResult Delete(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME)
{
DIM dIM = db.DIMs.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME);
if (dIM == null)
{
return(HttpNotFound());
}
return(View(dIM));
}
public ActionResult Details(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, string sClient)
{
DIM dIM = db.DIMs.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME);
if (dIM == null)
{
return(HttpNotFound());
}
ViewBag.sClient = sClient;
return(View(dIM));
}
public ActionResult Edit([Bind(Include = "CONFIG_COMMON_NAME,DIM_TYPE_GUID,DIM_COMMON_NAME,DIM_TABLE_SCHEMA,DIM_TABLE_NAME,DIM_LOAD_PROC_SCHEMA_RAW,DIM_LOAD_PROC_NAME_RAW,DIM_TABLE_CLEAN_SCHEMA,DIM_TABLE_CLEAN_NAME,DIM_PROC_UI_CLEAN_SCHEMA,DIM_PROC_UI_CLEAN_NAME,DIM_LOAD_PROC_CLEAN_SCHEMA,DIM_LOAD_PROC_CLEAN_NAME,DIM_VIEW_WHITELIST_SCHEMA,DIM_VIEW_WHITELIST_NAME,DIM_VIEW_RAW_SCHEMA,DIM_VIEW_RAW_NAME,DIM_VIEW_CLEAN_SCHEMA,DIM_VIEW_CLEAN_NAME,DIM_PROC_RAW_TABLE_CLEAN_ID_SCHEMA,DIM_PROC_RAW_TABLE_CLEAN_ID_NAME,DIM_FEATURE,DIM_TAXONOMY_PROC_SCHEMA,DIM_TAXONOMY_PROC_NAME,DIM_LOAD_PRE_PROC_SPROC_SCHEMA,DIM_LOAD_PRE_PROC_SPROC_NAME,DIM_LOAD_POST_PROC_SCHEMA,DIM_LOAD_POST_PROC_NAME,DIM_LOAD_PRE_PROC_CLEAN_SCHEMA,DIM_LOAD_PRE_PROC_CLEAN_NAME,DIM_LOAD_POST_PROC_CLEAN_SCHEMA,DIM_LOAD_POST_PROC_CLEAN_NAME,IS_STATIC,IS_AUTO_GENERATED")] DIM dIM, string[] SelectedItems, string CONFIG_COMMON_NAME, string DIM_COMMON_NAME)
{
if (SelectedItems != null)
{
bool exists = BitwiseDictionaryChecker.IsExists(ref feature, SelectedItems, "DIM", db);
dIM.DIM_FEATURE = feature;
if (!exists)
{
ModelState.AddModelError(String.Empty, "Cannot Edit due to invalid Features.");
return(RedirectToAction("Edit", new { CONFIG_COMMON_NAME = Request["CONFIG_COMMON_NAME"].ToString(), DIM_COMMON_NAME = Request["DIM_COMMON_NAME"].ToString() }));
}
}
if (ModelState.IsValid)
{
//TODO: come back here
string oldDIM_COMMON_NAME = Request["DIM_COMMON_NAME"].ToString();
string oldCONFIG_COMMON_NAME = Request["CONFIG_COMMON_NAME"].ToString();
if (oldDIM_COMMON_NAME != dIM.DIM_COMMON_NAME || oldCONFIG_COMMON_NAME != dIM.CONFIG_COMMON_NAME)
{
var dims = db.DIMs.Where(a => a.DIM_COMMON_NAME == oldDIM_COMMON_NAME && a.CONFIG_COMMON_NAME == oldCONFIG_COMMON_NAME);
foreach (var f in dims)
{
db.DIMs.Remove(f);
}
db.DIMs.Add(dIM);
}
else
{
db.Entry(dIM).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, ex.InnerException.InnerException.Message);
return(RedirectToAction("Edit", new { CONFIG_COMMON_NAME = Request["CONFIG_COMMON_NAME"].ToString(), DIM_COMMON_NAME = Request["DIM_COMMON_NAME"].ToString() }));
}
return(RedirectToAction("Index"));
}
return(View(dIM));
}
public ActionResult DeleteConfirmed(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME)
{
DIM dIM = db.DIMs.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME);
db.DIMs.Remove(dIM);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, ex.InnerException.InnerException.Message);
return(RedirectToAction("Delete", new { CONFIG_COMMON_NAME, DIM_COMMON_NAME }));
}
return(RedirectToAction("Index"));
}
private void parseDimension(SieDataItem di)
{
var d = di.GetString(0);
var n = di.GetString(1);
if (!DIM.ContainsKey(d))
{
DIM.Add(d, new SieDimension()
{
Name = n, Number = d
});
}
else
{
DIM[d].Name = n;
DIM[d].IsDefault = false;
}
}
/// <summary>
/// Build bayplan.
/// Original from http://www.smdg.org/assets/assets/BAPLIE3.1.1-02.pdf?
/// </summary>
static TSBAPLIE BuildBayplan(string controlNumber)
{
var result = new TSBAPLIE();
// Message header (ref id = M-EX1/1)
result.UNH = new UNH();
result.UNH.MessageReferenceNumber_01 = controlNumber.PadLeft(14, '0');
result.UNH.MessageIdentifier_02 = new S009();
result.UNH.MessageIdentifier_02.MessageType_01 = "BAPLIE";
result.UNH.MessageIdentifier_02.MessageVersionNumber_02 = "D";
result.UNH.MessageIdentifier_02.MessageReleaseNumber_03 = "13B";
result.UNH.MessageIdentifier_02.ControllingAgencyCoded_04 = "UN";
result.UNH.MessageIdentifier_02.AssociationAssignedCode_05 = "SMDG31";
// Partial BAPLIE(code 659), loaded containers only(LOADONLY), final stage(code 38)
result.BGM = new BGM();
result.BGM.DOCUMENTMESSAGENAME_01 = new C002();
result.BGM.DOCUMENTMESSAGENAME_01.Documentnamecode_01 = "659";
result.BGM.DOCUMENTMESSAGENAME_01.Codelistresponsibleagencycode_03 = "LOADONLY";
result.BGM.DOCUMENTMESSAGEIDENTIFICATION_02 = new C106();
result.BGM.DOCUMENTMESSAGEIDENTIFICATION_02.Documentidentifier_01 = "M-EX1/1";
result.BGM.Responsetypecode_04 = "38";
// Repeating DTM
result.DTM = new List <DTM>();
// Date/time (UTC) when message has been prepared
var dtm1 = new DTM();
dtm1.DATETIMEPERIOD_01 = new C507();
dtm1.DATETIMEPERIOD_01.Dateortimeorperiodfunctioncodequalifier_01 = "137";
dtm1.DATETIMEPERIOD_01.Dateortimeorperiodtext_02 = "201304130959";
dtm1.DATETIMEPERIOD_01.Dateortimeorperiodformatcode_03 = "203";
result.DTM.Add(dtm1);
// Repeating NAD Groups
result.NADLoop = new List <Loop_NAD_BAPLIE>();
// Begin NAD Group
var nadLoop1 = new Loop_NAD_BAPLIE();
// Function of sender (terminal)
nadLoop1.NAD = new NAD();
nadLoop1.NAD.Partyfunctioncodequalifier_01 = "WZ";
nadLoop1.NAD.PARTYIDENTIFICATIONDETAILS_02 = new C082();
nadLoop1.NAD.PARTYIDENTIFICATIONDETAILS_02.Partyidentifier_01 = "HNE";
nadLoop1.NAD.PARTYIDENTIFICATIONDETAILS_02.Codelistidentificationcode_02 = "TERMINALS";
nadLoop1.NAD.PARTYIDENTIFICATIONDETAILS_02.Codelistresponsibleagencycode_03 = "306";
// End NAD Group
result.NADLoop.Add(nadLoop1);
// Repeating TDT Groups
result.TDTLoop = new List <Loop_TDT_BAPLIE>();
// Begin TDT Group
var tdtLoop1 = new Loop_TDT_BAPLIE();
// Discharge voyage number, vessel operator, vessel identification
tdtLoop1.TDT = new TDT();
tdtLoop1.TDT.Transportstagecodequalifier_01 = "20";
tdtLoop1.TDT.Meansoftransportjourneyidentifier_02 = "123W45";
tdtLoop1.TDT.CARRIER_05 = new C040();
tdtLoop1.TDT.CARRIER_05.Carrieridentifier_01 = "HLC";
tdtLoop1.TDT.CARRIER_05.Codelistidentificationcode_02 = "LINES";
tdtLoop1.TDT.CARRIER_05.Codelistresponsibleagencycode_03 = "306";
tdtLoop1.TDT.EXCESSTRANSPORTATIONINFORMATION_07 = new C401();
tdtLoop1.TDT.EXCESSTRANSPORTATIONINFORMATION_07.Excesstransportationreasoncode_01 = "9354351";
tdtLoop1.TDT.EXCESSTRANSPORTATIONINFORMATION_07.Excesstransportationresponsibilitycode_02 = "11";
tdtLoop1.TDT.EXCESSTRANSPORTATIONINFORMATION_07.Customershipmentauthorisationidentifier_03 = "ANINA";
// Loading voyage number
tdtLoop1.RFF = new RFF();
tdtLoop1.RFF.REFERENCE_01 = new C506();
tdtLoop1.RFF.REFERENCE_01.Referencecodequalifier_01 = "VON";
tdtLoop1.RFF.REFERENCE_01.Referenceidentifier_02 = "123E38";
// Repeating LOC TDT Groups
tdtLoop1.LOCLoop = new List <Loop_LOC_BAPLIE_2>();
// Begin LOC TDT Group 1
var locTdtLoop1 = new Loop_LOC_BAPLIE_2();
// Place of departure
locTdtLoop1.LOC = new LOC();
locTdtLoop1.LOC.Locationfunctioncodequalifier_01 = "5";
locTdtLoop1.LOC.LOCATIONIDENTIFICATION_02 = new C517();
locTdtLoop1.LOC.LOCATIONIDENTIFICATION_02.Locationidentifier_01 = "BEANR";
// Repeating DTM
locTdtLoop1.DTM = new List <DTM>();
// Actual departure time
var dtmLoc1 = new DTM();
dtmLoc1.DATETIMEPERIOD_01 = new C507();
dtmLoc1.DATETIMEPERIOD_01.Dateortimeorperiodfunctioncodequalifier_01 = "136";
dtmLoc1.DATETIMEPERIOD_01.Dateortimeorperiodtext_02 = "201304301048";
dtmLoc1.DATETIMEPERIOD_01.Dateortimeorperiodformatcode_03 = "203";
locTdtLoop1.DTM.Add(dtmLoc1);
// End LOC TDT Group 1
tdtLoop1.LOCLoop.Add(locTdtLoop1);
// Begin LOC TDT Group 2
var locTdtLoop2 = new Loop_LOC_BAPLIE_2();
// Next port of call
locTdtLoop2.LOC = new LOC();
locTdtLoop2.LOC.Locationfunctioncodequalifier_01 = "61";
locTdtLoop2.LOC.LOCATIONIDENTIFICATION_02 = new C517();
locTdtLoop2.LOC.LOCATIONIDENTIFICATION_02.Locationidentifier_01 = "FRLEH";
// Repeating DTM
locTdtLoop2.DTM = new List <DTM>();
// Estimated arrival time
var dtmLoc2 = new DTM();
dtmLoc2.DATETIMEPERIOD_01 = new C507();
dtmLoc2.DATETIMEPERIOD_01.Dateortimeorperiodfunctioncodequalifier_01 = "178";
dtmLoc2.DATETIMEPERIOD_01.Dateortimeorperiodtext_02 = "201305012100";
dtmLoc2.DATETIMEPERIOD_01.Dateortimeorperiodformatcode_03 = "203";
locTdtLoop2.DTM.Add(dtmLoc2);
// End LOC TDT Group 2
tdtLoop1.LOCLoop.Add(locTdtLoop2);
// End TDT Group
result.TDTLoop.Add(tdtLoop1);
// End of message header
result.UNS = new UNS();
result.UNS.Sectionidentification_01 = "D";
// Repeating LOC Groups
result.LOCLoop = new List <Loop_LOC_BAPLIE>();
// Begin LOC Group 1
var locLoop1 = new Loop_LOC_BAPLIE();
// Stowage location (used)
locLoop1.LOC = new LOC();
locLoop1.LOC.Locationfunctioncodequalifier_01 = "147";
locLoop1.LOC.LOCATIONIDENTIFICATION_02 = new C517();
locLoop1.LOC.LOCATIONIDENTIFICATION_02.Locationidentifier_01 = "0200688";
locLoop1.LOC.LOCATIONIDENTIFICATION_02.Codelistidentificationcode_02 = "9711";
locLoop1.LOC.LOCATIONIDENTIFICATION_02.Codelistresponsibleagencycode_03 = "5";
// Repeating EQD Groups
locLoop1.EQDLoop = new List <Loop_EQD_BAPLIE>();
// Begin EQD Group
var eqdLocLoop1 = new Loop_EQD_BAPLIE();
// 40' open top container
eqdLocLoop1.EQD = new EQD();
eqdLocLoop1.EQD.Equipmenttypecodequalifier_01 = "CN";
eqdLocLoop1.EQD.EQUIPMENTIDENTIFICATION_02 = new C237();
eqdLocLoop1.EQD.EQUIPMENTIDENTIFICATION_02.Equipmentidentifier_01 = "SUDU1234569";
eqdLocLoop1.EQD.EQUIPMENTIDENTIFICATION_02.Codelistidentificationcode_02 = "6346";
eqdLocLoop1.EQD.EQUIPMENTIDENTIFICATION_02.Codelistresponsibleagencycode_03 = "5";
eqdLocLoop1.EQD.EQUIPMENTSIZEANDTYPE_03 = new C224();
eqdLocLoop1.EQD.EQUIPMENTSIZEANDTYPE_03.Equipmentsizeandtypedescriptioncode_01 = "42U0";
eqdLocLoop1.EQD.EQUIPMENTSIZEANDTYPE_03.Codelistidentificationcode_02 = "6346";
eqdLocLoop1.EQD.EQUIPMENTSIZEANDTYPE_03.Codelistresponsibleagencycode_03 = "5";
eqdLocLoop1.EQD.Fulloremptyindicatorcode_06 = "5";
// Repeating NAD
eqdLocLoop1.NAD = new List <NAD>();
// Container operator (HSD)
var nadEqd1 = new NAD();
nadEqd1.Partyfunctioncodequalifier_01 = "CF";
nadEqd1.PARTYIDENTIFICATIONDETAILS_02 = new C082();
nadEqd1.PARTYIDENTIFICATIONDETAILS_02.Partyidentifier_01 = "HSD";
nadEqd1.PARTYIDENTIFICATIONDETAILS_02.Codelistidentificationcode_02 = "LINES";
nadEqd1.PARTYIDENTIFICATIONDETAILS_02.Codelistresponsibleagencycode_03 = "306";
eqdLocLoop1.NAD.Add(nadEqd1);
// Repeating MEA
eqdLocLoop1.MEA = new List <MEA>();
// Gross weight (22.6 t)
var meaEqd1 = new MEA();
meaEqd1.Measurementpurposecodequalifier_01 = "AAE";
meaEqd1.MEASUREMENTDETAILS_02 = new C502();
meaEqd1.MEASUREMENTDETAILS_02.Measuredattributecode_01 = "AET";
meaEqd1.VALUERANGE_03 = new C174();
meaEqd1.VALUERANGE_03.Measurementunitcode_01 = "KGM";
meaEqd1.VALUERANGE_03.Measure_02 = "22600";
eqdLocLoop1.MEA.Add(meaEqd1);
// Repeating DIM
eqdLocLoop1.DIM = new List <DIM>();
// Overheight (92 cm)
var dimEqd1 = new DIM();
dimEqd1.Dimensiontypecodequalifier_01 = "13";
dimEqd1.DIMENSIONS_02 = new C211();
dimEqd1.DIMENSIONS_02.Measurementunitcode_01 = "CMT";
dimEqd1.DIMENSIONS_02.Heightmeasure_04 = "92";
eqdLocLoop1.DIM.Add(dimEqd1);
// End EQD Group
locLoop1.EQDLoop.Add(eqdLocLoop1);
// Control total
locLoop1.CNT = new CNT();
locLoop1.CNT.CONTROL_01 = new C270();
locLoop1.CNT.CONTROL_01.Controlqualifier_01 = "8";
locLoop1.CNT.CONTROL_01.Controlvalue_02 = "1";
// End LOC Group 1
result.LOCLoop.Add(locLoop1);
// Begin LOC Group 2
var locLoop2 = new Loop_LOC_BAPLIE();
// Stowage location (blocked)
locLoop2.LOC = new LOC();
locLoop2.LOC.Locationfunctioncodequalifier_01 = "147";
locLoop2.LOC.LOCATIONIDENTIFICATION_02 = new C517();
locLoop2.LOC.LOCATIONIDENTIFICATION_02.Locationidentifier_01 = "0200690";
locLoop2.LOC.LOCATIONIDENTIFICATION_02.Codelistidentificationcode_02 = "9711";
locLoop2.LOC.LOCATIONIDENTIFICATION_02.Codelistresponsibleagencycode_03 = "5";
// Repeating FTX
locLoop2.FTX = new List <FTX>();
// Lost slot
var ftxLoc1 = new FTX();
ftxLoc1.Textsubjectcodequalifier_01 = "AGW";
ftxLoc1.TEXTREFERENCE_03 = new C107();
ftxLoc1.TEXTREFERENCE_03.Freetextdescriptioncode_01 = "LOST";
ftxLoc1.TEXTREFERENCE_03.Codelistidentificationcode_02 = "STOWLOC";
ftxLoc1.TEXTREFERENCE_03.Codelistresponsibleagencycode_03 = "306";
locLoop2.FTX.Add(ftxLoc1);
// Equipment causing lost slot
locLoop2.RFF = new RFF();
locLoop2.RFF.REFERENCE_01 = new C506();
locLoop2.RFF.REFERENCE_01.Referencecodequalifier_01 = "EQ";
locLoop2.RFF.REFERENCE_01.Referenceidentifier_02 = "SUDU123459";
// Control total
locLoop2.CNT = new CNT();
locLoop2.CNT.CONTROL_01 = new C270();
locLoop2.CNT.CONTROL_01.Controlqualifier_01 = "8";
locLoop2.CNT.CONTROL_01.Controlvalue_02 = "0";
// End LOC Group 2
result.LOCLoop.Add(locLoop2);
return(result);
}
private void InitializeDimensions()
{
DIM.Add("1", new SieDimension()
{
Number = "1", Name = "Resultatenhet", IsDefault = true
});
DIM.Add("2", new SieDimension()
{
Number = "2", Name = "Kostnadsbärare", SuperDim = DIM["1"], IsDefault = true
});
DIM.Add("3", new SieDimension()
{
Number = "3", Name = "Reserverat", IsDefault = true
});
DIM.Add("4", new SieDimension()
{
Number = "4", Name = "Reserverat", IsDefault = true
});
DIM.Add("5", new SieDimension()
{
Number = "5", Name = "Reserverat", IsDefault = true
});
DIM.Add("6", new SieDimension()
{
Number = "6", Name = "Projekt", IsDefault = true
});
DIM.Add("7", new SieDimension()
{
Number = "7", Name = "Anställd", IsDefault = true
});
DIM.Add("8", new SieDimension()
{
Number = "8", Name = "Kund", IsDefault = true
});
DIM.Add("9", new SieDimension()
{
Number = "9", Name = "Leverantör", IsDefault = true
});
DIM.Add("10", new SieDimension()
{
Number = "10", Name = "Faktura", IsDefault = true
});
DIM.Add("11", new SieDimension()
{
Number = "11", Name = "Reserverat", IsDefault = true
});
DIM.Add("12", new SieDimension()
{
Number = "12", Name = "Reserverat", IsDefault = true
});
DIM.Add("13", new SieDimension()
{
Number = "13", Name = "Reserverat", IsDefault = true
});
DIM.Add("14", new SieDimension()
{
Number = "14", Name = "Reserverat", IsDefault = true
});
DIM.Add("15", new SieDimension()
{
Number = "15", Name = "Reserverat", IsDefault = true
});
DIM.Add("16", new SieDimension()
{
Number = "16", Name = "Reserverat", IsDefault = true
});
DIM.Add("17", new SieDimension()
{
Number = "17", Name = "Reserverat", IsDefault = true
});
DIM.Add("18", new SieDimension()
{
Number = "18", Name = "Reserverat", IsDefault = true
});
DIM.Add("19", new SieDimension()
{
Number = "19", Name = "Reserverat", IsDefault = true
});
}
public ActionResult Create([Bind(Include = "CONFIG_COMMON_NAME,DIM_TYPE_GUID,DIM_COMMON_NAME,DIM_TABLE_SCHEMA,DIM_TABLE_NAME,DIM_LOAD_PROC_SCHEMA_RAW,DIM_LOAD_PROC_NAME_RAW,DIM_TABLE_CLEAN_SCHEMA,DIM_TABLE_CLEAN_NAME,DIM_PROC_UI_CLEAN_SCHEMA,DIM_PROC_UI_CLEAN_NAME,DIM_LOAD_PROC_CLEAN_SCHEMA,DIM_LOAD_PROC_CLEAN_NAME,DIM_VIEW_WHITELIST_SCHEMA,DIM_VIEW_WHITELIST_NAME,DIM_VIEW_RAW_SCHEMA,DIM_VIEW_RAW_NAME,DIM_VIEW_CLEAN_SCHEMA,DIM_VIEW_CLEAN_NAME,DIM_PROC_RAW_TABLE_CLEAN_ID_SCHEMA,DIM_PROC_RAW_TABLE_CLEAN_ID_NAME,DIM_FEATURE,DIM_TAXONOMY_PROC_SCHEMA,DIM_TAXONOMY_PROC_NAME,DIM_LOAD_PRE_PROC_SPROC_SCHEMA,DIM_LOAD_PRE_PROC_SPROC_NAME,DIM_LOAD_POST_PROC_SCHEMA,DIM_LOAD_POST_PROC_NAME,DIM_LOAD_PRE_PROC_CLEAN_SCHEMA,DIM_LOAD_PRE_PROC_CLEAN_NAME,DIM_LOAD_POST_PROC_CLEAN_SCHEMA,DIM_LOAD_POST_PROC_CLEAN_NAME,IS_STATIC,IS_AUTO_GENERATED")] string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, DIM dIM, string[] SelectedItems)
{
dIM.CONFIG_COMMON_NAME = Session["sClient"].ToString();
if (SelectedItems != null)
{
bool exists = BitwiseDictionaryChecker.IsExists(ref feature, SelectedItems, "DIM", db);
dIM.DIM_FEATURE = feature;
if (!exists)
{
ModelState.AddModelError(String.Empty, "Cannot create due to selection of invalid features.");
return(RedirectToAction("Create", new { CONFIG_COMMON_NAME = Request["CONFIG_COMMON_NAME"].ToString(), DIM_COMMON_NAME = Request["DIM_COMMON_NAME"].ToString() }));
}
}
if (ModelState.IsValid)
{
try
{
db.DIMs.Add(dIM);
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, ex.InnerException.InnerException.Message);
return(RedirectToAction("Create", new { CONFIG_COMMON_NAME, DIM_COMMON_NAME }));
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dIM));
}
