public void CalificationProjectConfigItemUpsert()
{
CalificationProjectConfigModel oReturn = new CalificationProjectConfigModel()
{
CalificationProjectConfigId = 1,
ConfigItemModel = new List <ConfigItemModel>()
{
new ConfigItemModel()
{
CalificationProjectConfigItemId = 5,
CalificationProjectConfigItemName = null,
CalificationProjectConfigItemType = new Company.Models.Util.CatalogModel()
{
ItemId = 2003002, //Módulo Financiera
},
Enable = true,
},
},
};
oReturn = ProveedoresOnLine.CalificationProject.Controller.CalificationProject.CalificationProjectConfigItemUpsert
(oReturn);
Assert.AreEqual(true, oReturn.CalificationProjectConfigId > 0 && oReturn.ConfigItemModel != null && oReturn.ConfigItemModel.Count > 0);
}
public void CalificaciontProjectConfigUpsert()
{
CalificationProjectConfigModel oReturn = new CalificationProjectConfigModel()
{
CalificationProjectConfigId = 0,
CalificationProjectConfigName = "Proceso de Calificación Prueba 1",
Company = new Company.Models.Company.CompanyModel()
{
CompanyPublicId = "1EA5A78A"
},
Enable = true
};
oReturn = ProveedoresOnLine.CalificationProject.Controller.CalificationProject.CalificationProjectConfigUpsert(oReturn);
Assert.AreEqual(true, oReturn.CalificationProjectConfigId > 0);
}
public Models.CalificationProject.CalificationProjectConfigModel CalificationProjectConfig_GetByCalificationProjectConfigId(int CalificationProjectConfigId)
{
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vCalificationProjectConfigId", CalificationProjectConfigId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "CC_CalificationProjectConfig_GetByCalificationProjectConfigId",
CommandType = CommandType.StoredProcedure,
Parameters = lstParams,
});
Models.CalificationProject.CalificationProjectConfigModel oReturn = new CalificationProjectConfigModel();
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn = (from cpc in response.DataTableResult.AsEnumerable()
where !cpc.IsNull("CalificationProjectConfigId")
group cpc by new
{
CalificationProjectConfigId = cpc.Field <int>("CalificationProjectConfigId"),
CalificationProjectConfigName = cpc.Field <string>("CalificationProjectConfigName"),
CompanyPublicId = cpc.Field <string>("CompanyPublicId"),
Enable = cpc.Field <UInt64>("Enable") == 1 ? true : false,
LastModify = cpc.Field <DateTime>("LastModify"),
CreateDate = cpc.Field <DateTime>("CreateDate"),
}
into cpcg
select new CalificationProject.Models.CalificationProject.CalificationProjectConfigModel()
{
CalificationProjectConfigId = cpcg.Key.CalificationProjectConfigId,
CalificationProjectConfigName = cpcg.Key.CalificationProjectConfigName,
Enable = cpcg.Key.Enable,
Company = new Company.Models.Company.CompanyModel()
{
CompanyPublicId = cpcg.Key.CompanyPublicId,
},
LastModify = cpcg.Key.LastModify,
CreateDate = cpcg.Key.CreateDate,
}).FirstOrDefault();
}
return(oReturn);
}
public static CalificationProjectConfigModel CalificationProjectConfigUpsert(CalificationProjectConfigModel oConfigProject)
{
LogManager.Models.LogModel oLog = Company.Controller.Company.GetGenericLogModel();
try
{
if (oConfigProject != null)
{
oConfigProject.CalificationProjectConfigId = DAL.Controller.CalificationProjectDataController.Instance.CalificationProjectConfigUpsert
(
oConfigProject.CalificationProjectConfigId,
oConfigProject.Company.CompanyPublicId,
oConfigProject.CalificationProjectConfigName,
oConfigProject.Enable
);
oLog.IsSuccess = true;
}
}
catch (Exception err)
{
oLog.IsSuccess = false;
oLog.Message = err.Message + " - " + err.StackTrace;
throw err;
}
finally
{
oLog.LogObject = oConfigProject;
oLog.RelatedLogInfo.Add(new LogManager.Models.LogInfoModel()
{
LogInfoType = "CalificationProjectConfigId",
Value = oConfigProject.CalificationProjectConfigId.ToString()
});
LogManager.ClientLog.AddLog(oLog);
}
return(oConfigProject);
}
public static CalificationProjectConfigModel CalificationProjectConfigItemUpsert(CalificationProjectConfigModel oCalificationProjectConfigModel)
{
if (oCalificationProjectConfigModel != null &&
oCalificationProjectConfigModel.ConfigItemModel != null &&
oCalificationProjectConfigModel.ConfigItemModel.Count > 0)
{
oCalificationProjectConfigModel.ConfigItemModel.All(cit =>
{
LogManager.Models.LogModel oLog = Company.Controller.Company.GetGenericLogModel();
try
{
cit.CalificationProjectConfigItemId = DAL.Controller.CalificationProjectDataController.Instance.CalificationProjectConfigItemUpsert
(oCalificationProjectConfigModel.CalificationProjectConfigId,
cit.CalificationProjectConfigItemId,
cit.CalificationProjectConfigItemName,
cit.CalificationProjectConfigItemType.ItemId,
cit.Enable);
oLog.IsSuccess = true;
}
catch (Exception err)
{
oLog.IsSuccess = false;
oLog.Message = err.Message + " - " + err.StackTrace;
throw err;
}
finally
{
oLog.LogObject = cit;
oLog.RelatedLogInfo.Add(new LogManager.Models.LogInfoModel()
{
LogInfoType = "CalificationProjectConfigItemId",
Value = cit.CalificationProjectConfigItemId.ToString(),
});
LogManager.ClientLog.AddLog(oLog);
}
return(true);
});
}
return(oCalificationProjectConfigModel);
}
