internal ItmMasXml ValidateAndInsertItmMas(string EnvironmentName, string ItmCd, string ItmTyp, string ItmNm, int CKy, int UsrKy, int ItmTypKy = 0,
int BrandKy = 0, int ModelKy = 0, int ItmCat1Ky = 0, int ItmCat2Ky = 0, int ItmCat3Ky = 0, int ItmCat4Ky = 0, int ItmCat5Ky = 0, int ItmCat6Ky = 0, int ItmCat7Ky = 0, int ItmCat8Ky = 0, int ItmCat9Ky = 0, int ItmCat10Ky = 0, int ItmCat11Ky = 0, int ItmCat12Ky = 0,
int UnitKy = 0, double ReOrdLvl = 0, double ReOrdQty = 0, bool isAct = true, bool isAgeVarification = false, bool isAlwTrnRateChange = false)
{
string actionUri = "ValidateAndInsertItmMas";
Dictionary <string, object> paramDictionary = new Dictionary <string, object>();
paramDictionary.Add("CKy", CKy);
paramDictionary.Add("UsrKy", UsrKy);
paramDictionary.Add("ItmCd", ItmCd);
paramDictionary.Add("ItmTyp", ItmTyp);
paramDictionary.Add("ItmNm", ItmNm);
paramDictionary.Add("ItmTypKy", ItmTypKy);
paramDictionary.Add("BrandKy", BrandKy);
paramDictionary.Add("ModelKy", ModelKy);
paramDictionary.Add("UnitKy", UnitKy);
paramDictionary.Add("ItmCat1Ky", ItmCat1Ky);
paramDictionary.Add("ItmCat2Ky", ItmCat2Ky);
paramDictionary.Add("ItmCat3Ky", ItmCat3Ky);
paramDictionary.Add("ItmCat4Ky", ItmCat4Ky);
paramDictionary.Add("ItmCat5Ky", ItmCat5Ky);
paramDictionary.Add("ItmCat6Ky", ItmCat6Ky);
paramDictionary.Add("ItmCat7Ky", ItmCat7Ky);
paramDictionary.Add("ItmCat8Ky", ItmCat8Ky);
paramDictionary.Add("ItmCat9Ky", ItmCat9Ky);
paramDictionary.Add("ItmCat10Ky", ItmCat10Ky);
paramDictionary.Add("ItmCat11Ky", ItmCat11Ky);
paramDictionary.Add("ItmCat12Ky", ItmCat12Ky);
paramDictionary.Add("isAct", isAct);
paramDictionary.Add("isAgeVarification", isAgeVarification);
paramDictionary.Add("isAlwTrnRateChange", isAlwTrnRateChange);
paramDictionary.Add("ReOrdLvl", ReOrdLvl);
paramDictionary.Add("ReOrdQty", ReOrdQty);
ItmMasXml list = new ItmMasXml();
list = RunApiOperation(
validateAndInsertBaseUri,
actionUri,
EnvironmentName,
paramDictionary,
list.GetType()) as ItmMasXml;
return(list);
}
internal List <SelectProjectScheduleDetails> SetMSExcelImportJsonData(string EnvironmentName, int PrjKy, int PrcsSchKy, string MSImportStringData, int CKy, int UsrKy)
{
// -- Define New List
List <UnitXml> newUnitXml = new List <UnitXml>();
List <ItemTypeXml> newItemTypeXml = new List <ItemTypeXml>();
List <ItmMasXml> newResourceXml = new List <ItmMasXml>();
List <ItmMasXml> newTaskXml = new List <ItmMasXml>();
List <PrcsDetXml> newPMTaskXml = new List <PrcsDetXml>();
List <PrcsSchDetCmpnXml> newPMResourceXml = new List <PrcsSchDetCmpnXml>();
// -- Define New List
List <SelectProjectScheduleDetails> list = new List <SelectProjectScheduleDetails>();
List <PMExcel_ImportModel> listNew = new List <PMExcel_ImportModel>();
if (MSImportStringData != "[]" || MSImportStringData != "[null]" || MSImportStringData != "")
{
try
{
PMExcel_ImportModel task = new JavaScriptSerializer().Deserialize <PMExcel_ImportModel>(MSImportStringData);
if (task.UnitXml != null)
{
foreach (UnitXml unitXml in task.UnitXml)
{
try
{
if (unitXml != null)
{
UnitXml unt = ValidateAndInsertUnitMas(EnvironmentName, unitXml.Unit, CKy, UsrKy);
newUnitXml.Add(unt);
}
}
catch (Exception ex) { }
}
}
if (task.ItemTypeXml != null)
{
foreach (ItemTypeXml itemTypeXml in task.ItemTypeXml)
{
try
{
if (itemTypeXml != null)
{
CdMasXml it = ValidateAndInsertCdMas(EnvironmentName, itemTypeXml.ItemTypeCd, itemTypeXml.ItemTypeNm,
"ItmTyp", CKy, UsrKy, 0, itemTypeXml.ItemTypeCd);
ItemTypeXml itmTyp = new ItemTypeXml();
itmTyp.ItemTypeKy = it.CdKy;
itmTyp.ItemTypeCd = it.Code;
itmTyp.ItemTypeNm = it.CdNm;
newItemTypeXml.Add(itmTyp);
}
}
catch (Exception ex) { }
}
}
if (task.ResourceXml != null)
{
foreach (ResourceXml resourceXml in task.ResourceXml)
{
try
{
if (resourceXml != null)
{
ItmMasXml itm = ValidateAndInsertItmMas(EnvironmentName, resourceXml.ResourceID, resourceXml.ItemTypeCd, resourceXml.ResourceName, CKy, UsrKy);
newResourceXml.Add(itm);
}
}
catch (Exception ex) { }
}
}
if (task.TaskXml != null)
{
foreach (TaskXml taskXml in task.TaskXml)
{
try
{
if (taskXml != null)
{
ItmMasXml itm = ValidateAndInsertItmMas(EnvironmentName, taskXml.TaskCd, "Task", taskXml.TaskName, CKy, UsrKy);
newTaskXml.Add(itm);
}
}
catch (Exception ex) { }
}
}
int LiNo = 0;
if (task.PMTaskXml != null)
{
foreach (PMTaskXml pmTaskXml in task.PMTaskXml)
{
try
{
if (pmTaskXml != null)
{
LiNo++;
int untKy = pmTaskXml.Unit == null ? 1 : newUnitXml.Where(o => o.Unit.ToUpper() == pmTaskXml.Unit.ToUpper()).FirstOrDefault().UnitKy;
double qty = 0, rate = 0;
int intLvl = 0;
double.TryParse(pmTaskXml.Quantity, out qty);
double.TryParse(pmTaskXml.Rate, out rate);
int.TryParse(pmTaskXml.IndentLevel, out intLvl);
PrcsDetXml rtn = ValidateAndInsertPMTask(
EnvironmentName, PrjKy, PrcsSchKy,
pmTaskXml.TaskID, pmTaskXml.TaskName, LiNo.ToString(),
pmTaskXml.StartTime, pmTaskXml.EndTime, intLvl,
qty, rate, untKy, CKy, UsrKy);
newPMTaskXml.Add(rtn);
}
}
catch (Exception ex) { }
}
}
LiNo = 0;
if (task.PMResourceXml != null)
{
int tempPrcsDetKy = 1;
//task.PMResourceXml = task.PMResourceXml.OrderBy(o => o.TaskID).ToArray();
foreach (PMResourceXml pmResourceXml in task.PMResourceXml)
{
try
{
if (pmResourceXml != null)
{
int untKy = pmResourceXml.Unit == null ? 1 : newUnitXml.Where(o => o.Unit.ToUpper() == pmResourceXml.Unit.ToUpper()).FirstOrDefault().UnitKy;
int prcsDetKy = pmResourceXml.TaskID == null ? 1 : newPMTaskXml.Where(o => o.TaskID.ToUpper() == pmResourceXml.TaskID.ToUpper()).FirstOrDefault().PrcsDetKy;
int prcsSchDetKy = pmResourceXml.TaskID == null ? 1 : newPMTaskXml.Where(o => o.TaskID.ToUpper() == pmResourceXml.TaskID.ToUpper()).FirstOrDefault().PrcsSchDetKy;
int resKy = 1;
if (tempPrcsDetKy != prcsDetKy)
{
LiNo = 0;
}
tempPrcsDetKy = prcsDetKy;
LiNo++;
if (pmResourceXml.ResourceID.Length > 15)
{
resKy = pmResourceXml.ResourceID == null ? 1 : newResourceXml.Where(o => o.ItmCd.ToUpper() == pmResourceXml.ResourceID.ToUpper().Substring(0, 15)).FirstOrDefault().ItmKy;
}
else
{
resKy = pmResourceXml.ResourceID == null ? 1 : newResourceXml.Where(o => o.ItmCd.ToUpper() == pmResourceXml.ResourceID.ToUpper()).FirstOrDefault().ItmKy;
}
double qty = 0;
double.TryParse(pmResourceXml.Quantity, out qty);
PrcsSchDetCmpnXml rtn = ValidateAndInsertPMResource(
EnvironmentName, prcsSchDetKy, prcsDetKy,
1, resKy, 1, LiNo.ToString(), qty, qty, 0, 0, untKy, CKy, UsrKy);
newPMResourceXml.Add(rtn);
}
}
catch (Exception ex) { }
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
else
{
list = new System.Collections.Generic.List <SelectProjectScheduleDetails>();
}
return(list);
}
