public string CreateUserRolesUpsert(
int AplicationId,
int RoleId,
string UserEmail)
{
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vApplicationId", AplicationId));
lstParams.Add(DataInstance.CreateTypedParameter("vRoleId", RoleId));
lstParams.Add(DataInstance.CreateTypedParameter("vUserEmail", UserEmail));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.Scalar,
CommandText = "A_ApplicationRole_Create",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
if (response.ScalarResult != null)
{
return(response.ScalarResult.ToString());
}
else
{
return(null);
}
}
public int BOProviderUpsert(string ProviderPublicId, string ProviderName, string IdentificationType, string IdentificationNumber)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vProviderPublicId", ProviderPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vProviderName", ProviderName));
lstParams.Add(DataInstance.CreateTypedParameter("vIdentificationType", IdentificationType));
lstParams.Add(DataInstance.CreateTypedParameter("vIdentificationNumber", IdentificationNumber));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.Scalar,
CommandText = "AP_BOProviderUpsert",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams,
});
int oReturn = 0;
if (response.ScalarResult != null)
{
oReturn = Convert.ToInt32(response.ScalarResult);
}
return(oReturn);
}
public List <AdminRolesModel> ListUserRoles()
{
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "A_GetAllUsers",
CommandType = System.Data.CommandType.StoredProcedure
});
List <AdminRolesModel> oRetorno = null;
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oRetorno = (from au in response.DataTableResult.AsEnumerable()
select new AdminRolesModel()
{
RelatedRole = new SessionManager.Models.Auth.ApplicationRole()
{
ApplicationRoleId = au.Field <int>("ApplicationRoleId"),
Application = au.Field <enumApplication>("ApplicationId"),
Role = au.Field <enumRole>("RoleId"),
CreateDate = au.Field <DateTime>("CreateDate"),
},
UserEmail = au.Field <string>("UserEmail")
}).ToList();
}
return(oRetorno);
}
public CustomerModel CustomerGetById(string CustomerPublicId)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vCustomerPublicId", CustomerPublicId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "C_Customer_GetById",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
CustomerModel oReturn = null;
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn = new CustomerModel()
{
CustomerPublicId = response.DataTableResult.Rows[0].Field <string>("CustomerPublicId"),
Name = response.DataTableResult.Rows[0].Field <string>("Name"),
IdentificationType = new Models.Util.CatalogModel()
{
ItemId = response.DataTableResult.Rows[0].Field <int>("IdentificationTypeId"),
ItemName = response.DataTableResult.Rows[0].Field <string>("IdentificationTypeName"),
},
IdentificationNumber = response.DataTableResult.Rows[0].Field <string>("IdentificationNumber"),
};
}
return(oReturn);
}
public List <StepModel> StepGetByFormId(string FormPublicId)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vFormPublicId", FormPublicId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "F_Step_GetByFormId",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
List <StepModel> oReturn = new List <StepModel>();
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn =
(from s in response.DataTableResult.AsEnumerable()
where !s.IsNull("StepId")
select new StepModel()
{
StepId = s.Field <int>("StepId"),
Name = s.Field <string>("StepName"),
Position = s.Field <int>("StepPosition"),
}).ToList();
}
return(oReturn);
}
public string CustomerUpsert(string CustomerPublicId, string Name, int IdentificationType, string IdentificationNumber)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vCustomerPublicId", CustomerPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vName", Name));
lstParams.Add(DataInstance.CreateTypedParameter("vIdentificationType", IdentificationType));
lstParams.Add(DataInstance.CreateTypedParameter("vIdentificationNumber", IdentificationNumber));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.Scalar,
CommandText = "C_Customer_UpSert",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
if (response.ScalarResult != null)
{
return(response.ScalarResult.ToString());
}
else
{
return(null);
}
}
public List <ProveedoresOnLine.Company.Models.Util.CatalogModel> CatalogGetSanofiOptions()
{
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "Sanofi_Catalog_GetProviderOptions",
CommandType = CommandType.StoredProcedure,
});
List <ProveedoresOnLine.Company.Models.Util.CatalogModel> oReturn = new List <ProveedoresOnLine.Company.Models.Util.CatalogModel>();
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn =
(from c in response.DataTableResult.AsEnumerable()
where !c.IsNull("CatalogId")
select new ProveedoresOnLine.Company.Models.Util.CatalogModel()
{
CatalogId = c.Field <int>("CatalogId"),
CatalogName = c.Field <string>("CatalogName"),
ItemId = c.Field <int>("ItemId"),
ItemName = c.Field <string>("ItemName"),
}).ToList();
}
return(oReturn);
}
public List <CatalogModel> CatalogGetCustomerOptions()
{
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "U_Catalog_GetCustomerOptions",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = null
});
List <CatalogModel> oReturn = new List <CatalogModel>();
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn =
(from c in response.DataTableResult.AsEnumerable()
where !c.IsNull("ItemId")
select new CatalogModel()
{
CatalogId = c.Field <int>("CatalogId"),
CatalogName = c.Field <string>("CatalogName"),
ItemId = c.Field <int>("ItemId"),
ItemName = c.Field <string>("ItemName"),
}).ToList();
}
return(oReturn);
}
public SanofiProcessLogModel GetSanofiLastProcessLog()
{
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "Sanofi_LastProcessLog_Get",
CommandType = CommandType.StoredProcedure,
});
SanofiProcessLogModel oReturn = new SanofiProcessLogModel();
if (response.DataTableResult != null &&
!string.IsNullOrEmpty(response.DataTableResult.Rows[0].Field <string>("ProviderPublicId")))
{
oReturn = new SanofiProcessLogModel
{
SanofiProcessLogId = response.DataTableResult.Rows[0].Field <int>("SanofiProcessLogId"),
ProviderPublicId = response.DataTableResult.Rows[0].Field <string>("ProviderPublicId"),
ProcessName = response.DataTableResult.Rows[0].Field <string>("ProcessName"),
IsSucces = response.DataTableResult.Rows[0].Field <UInt64>("IsSuccess") == 1 ? true : false,
CreateDate = response.DataTableResult.Rows[0].Field <DateTime>("CreateDate"),
LastModify = response.DataTableResult.Rows[0].Field <DateTime>("lastModify")
};
}
return(oReturn);
}
public List <SanofiContableInfoModel> GetContableInfoByProvider(string vProviderPublicId)
{
List <System.Data.IDbDataParameter> lstparams = new List <System.Data.IDbDataParameter>();
lstparams.Add(DataInstance.CreateTypedParameter("vProviderPublicId", vProviderPublicId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "Sanofi_GetContableInfo",
CommandType = CommandType.StoredProcedure,
Parameters = lstparams,
});
List <SanofiContableInfoModel> oReturn = new List <SanofiContableInfoModel>();
if (response.DataTableResult != null && response.DataTableResult.Rows.Count > 0)
{
oReturn =
(
from sconi in response.DataTableResult.AsEnumerable()
where !sconi.IsNull("CompanyId")
group sconi by new
{
CompanyId = sconi.Field <int>("CompanyId"),
CompanyName = sconi.Field <string>("CompanyName"),
FiscalNumber = sconi.Field <string>("FiscalNumber"),
IdentificationNumber = sconi.Field <string>("IdentificationNumber"),
Country = sconi.Field <string>("Country"),
BankPassword = sconi.Field <string>("BankPassword"),
BankCountNumber = sconi.Field <string>("BankCountNumber"),
CountType = sconi.Field <Int64>("CountType"),
IBAN = sconi.Field <string>("IBAN"),
PayWay = sconi.Field <string>("PayWay"),
PayCondition = sconi.Field <string>("PayCondition"),
AssociatedCount = sconi.Field <string>("AssociatedCount")
}
into sconig
select new SanofiContableInfoModel()
{
CompanyId = sconig.Key.CompanyId,
CompanyName = sconig.Key.CompanyName,
FiscalNumber = sconig.Key.FiscalNumber,
IdentificationNumber = sconig.Key.IdentificationNumber,
Country = sconig.Key.Country,
BankPassword = sconig.Key.BankPassword,
BankCountNumber = sconig.Key.BankCountNumber,
CountType = sconig.Key.CountType,
IBAN = sconig.Key.IBAN,
PayWay = sconig.Key.PayWay,
PayCondition = sconig.Key.PayCondition,
AssociatedCount = sconig.Key.AssociatedCount
}).ToList();
}
return(oReturn);
}
public List <LogModel> LogSearch(string LogInfoType, string Value)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vLogInfoType", LogInfoType));
lstParams.Add(DataInstance.CreateTypedParameter("vValue", Value));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "L_Log_Search",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
List <LogModel> oReturn = new List <LogModel>();
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn =
(from l in response.DataTableResult.AsEnumerable()
group l by
new
{
LogId = l.Field <int>("LogId"),
User = l.Field <string>("User"),
Application = l.Field <string>("Application"),
Source = l.Field <string>("Source"),
IsSuccess = l.Field <UInt64>("IsSuccess") == 1 ? true : false,
Message = l.Field <string>("Message"),
CreateDate = l.Field <DateTime>("CreateDate"),
} into lg
select new LogModel()
{
LogId = lg.Key.LogId,
User = lg.Key.User,
Application = lg.Key.Application,
Source = lg.Key.Source,
IsSuccess = lg.Key.IsSuccess,
Message = lg.Key.Message,
CreateDate = lg.Key.CreateDate,
RelatedLogInfo =
(from li in response.DataTableResult.AsEnumerable()
where li.Field <int>("LogId") == lg.Key.LogId
select new LogInfoModel()
{
LogInfoId = li.Field <int>("LogInfoId"),
LogInfoType = li.Field <string>("LogInfoType"),
Value = li.Field <string>("Value"),
}).ToList(),
}).ToList();
}
return(oReturn);
}
public ProviderModel ProviderGetByIdentification(string IdentificationNumber, int IdenificationTypeId, string CustomerPublicId)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vIdentificationNumber", IdentificationNumber));
lstParams.Add(DataInstance.CreateTypedParameter("vIdenificationTypeId", IdenificationTypeId));
lstParams.Add(DataInstance.CreateTypedParameter("vCustomerPublicId", CustomerPublicId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "P_Provider_GetByIdentification",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
ProviderModel oReturn = null;
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn = new ProviderModel()
{
ProviderPublicId = response.DataTableResult.Rows[0].Field <string>("ProviderPublicId"),
Name = response.DataTableResult.Rows[0].Field <string>("Name"),
IdentificationType = new CatalogModel()
{
ItemId = response.DataTableResult.Rows[0].Field <int>("IdentificationTypeId"),
ItemName = response.DataTableResult.Rows[0].Field <string>("IdentificationTypeName"),
},
IdentificationNumber = response.DataTableResult.Rows[0].Field <string>("IdentificationNumber"),
Email = response.DataTableResult.Rows[0].Field <string>("Email"),
CustomerPublicId = response.DataTableResult.Rows[0].Field <string>("CustomerPublicId"),
CustomerName = response.DataTableResult.Rows[0].Field <string>("CustomerName"),
RelatedProviderCustomerInfo =
(from pci in response.DataTableResult.AsEnumerable()
where !pci.IsNull("ProviderCustomerInfoId")
select new ProviderInfoModel()
{
ProviderInfoId = pci.Field <int>("ProviderCustomerInfoId"),
ProviderInfoType = new CatalogModel()
{
ItemId = pci.Field <int>("ProviderCustomerInfoTypeId"),
ItemName = pci.Field <string>("ProviderCustomerInfoTypeName"),
},
Value = pci.Field <string>("ProviderCustomerInfoValue"),
LargeValue = pci.Field <string>("ProviderCustomerInfoLargeValue"),
}).ToList(),
};
}
return(oReturn);
}
public CompanyCustomer.Models.Customer.CustomerModel GetCustomerByProvider(string ProviderPublicId, string vCustomerRelated)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vProviderPublicId", ProviderPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vCustomerRelated", vCustomerRelated));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "CC_GetCustomerByProvider",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams,
});
CompanyCustomer.Models.Customer.CustomerModel oReturn = new Models.Customer.CustomerModel();
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn = new Models.Customer.CustomerModel()
{
RelatedProvider =
(from cpri in response.DataTableResult.AsEnumerable()
where !cpri.IsNull("CustomerPublicId")
group cpri by new
{
CustomerProviderId = cpri.Field <UInt64>("CustomerProviderId"),
CustomerPublicId = cpri.Field <string>("CustomerPublicId"),
CustomerName = cpri.Field <string>("CustomerName"),
StatusId = cpri.Field <UInt64>("StatusId"),
StatusName = cpri.Field <string>("StatusName"),
IsRelatedCustomer = cpri.Field <UInt64>("IsRelatedCustomer") == 1 ? true : false,
} into cprinf
select new ProveedoresOnLine.CompanyCustomer.Models.Customer.CustomerProviderModel()
{
CustomerProviderId = Convert.ToInt32(cprinf.Key.CustomerProviderId),
RelatedProvider = new Company.Models.Company.CompanyModel()
{
CompanyPublicId = cprinf.Key.CustomerPublicId,
CompanyName = cprinf.Key.CustomerName,
},
Status = new Company.Models.Util.CatalogModel()
{
ItemId = Convert.ToInt32(cprinf.Key.StatusId),
ItemName = cprinf.Key.StatusName,
},
Enable = cprinf.Key.IsRelatedCustomer,
}).ToList(),
};
}
return(oReturn);
}
public ProveedoresOnLine.AsociateProvider.Client.Models.HomologateModel GetHomologateItemBySourceID(Int32 SourceCode)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vSource", SourceCode));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "AP_GetHomologateItemBySourceId",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams,
});
ProveedoresOnLine.AsociateProvider.Client.Models.HomologateModel oReturn = null;
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn = new ProveedoresOnLine.AsociateProvider.Client.Models.HomologateModel()
{
HomologateId = response.DataTableResult.Rows[0].Field <int>("HomologateId"),
HomologateType = new ProveedoresOnLine.AsociateProvider.Client.Models.CatalogModel()
{
CatalogId = response.DataTableResult.Rows[0].Field <int>("HomologateTypecatalogId"),
CatalogName = response.DataTableResult.Rows[0].Field <string>("HomologateTypecatalogName"),
ItemId = response.DataTableResult.Rows[0].Field <int>("HomologateTypeId"),
ItemName = response.DataTableResult.Rows[0].Field <string>("HomologateTypeName"),
},
Source = new ProveedoresOnLine.AsociateProvider.Client.Models.CatalogModel()
{
CatalogId = response.DataTableResult.Rows[0].Field <int>("SourceCatalogId"),
CatalogName = response.DataTableResult.Rows[0].Field <string>("SourceCatalogName"),
ItemId = response.DataTableResult.Rows[0].Field <int>("SourceTypeId"),
ItemName = response.DataTableResult.Rows[0].Field <string>("SourceTypeName"),
},
Target = new ProveedoresOnLine.AsociateProvider.Client.Models.CatalogModel()
{
CatalogId = response.DataTableResult.Rows[0].Field <int>("TargetCatalogId"),
CatalogName = response.DataTableResult.Rows[0].Field <string>("TargetCatalogName"),
ItemId = response.DataTableResult.Rows[0].Field <int>("TargetTypeId"),
ItemName = response.DataTableResult.Rows[0].Field <string>("TargetTypeName"),
},
CreateDate = response.DataTableResult.Rows[0].Field <DateTime>("CreateDate"),
LastModify = response.DataTableResult.Rows[0].Field <DateTime>("LastModify"),
};
}
return(oReturn);
}
public List <NotificationModel> NotificationGetByUser(string CompanyPublicId, string User, bool Enable)
{
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vCompanyPublicId", CompanyPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vUser", User));
lstParams.Add(DataInstance.CreateTypedParameter("vEnable", Enable == true ? 1 : 0));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "N_Notification_GetByUser",
CommandType = CommandType.StoredProcedure,
Parameters = lstParams,
});
List <NotificationModel> oReturn = null;
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn =
(from n in response.DataTableResult.AsEnumerable()
where !n.IsNull("NotificationId")
group n by new
{
NotificationId = n.Field <int>("NotificationId"),
CompanyPublicId = n.Field <string>("CompanyPublicId"),
Label = n.Field <string>("Label"),
Url = n.Field <string>("Url"),
User = n.Field <string>("User"),
NotificationType = n.Field <int>("NotificationType"),
NotificationEnable = n.Field <UInt64>("NotificationEnable"),
LastModify = n.Field <DateTime>("LastModify"),
CreateDate = n.Field <DateTime>("CreateDate"),
}
into ng
select new NotificationModel()
{
NotificationId = ng.Key.NotificationId,
CompanyPublicId = ng.Key.CompanyPublicId,
Label = ng.Key.Label,
Url = ng.Key.Url,
User = ng.Key.User,
NotificationType = ng.Key.NotificationType,
Enable = ng.Key.NotificationEnable == 1 ? true : false,
LastModify = ng.Key.LastModify,
CreateDate = ng.Key.CreateDate,
}).ToList();
}
return(oReturn);
}
public List <Models.CalificationProject.ConfigValidateModel> CalificationProjectConfigValidate_GetByProjectConfigId(int CalificationProjectConfigId, bool Enable)
{
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vCalificationProjectConfigId", CalificationProjectConfigId));
lstParams.Add(DataInstance.CreateTypedParameter("vEnable", Enable == true ? 1 : 0));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "CC_CalificationProjectConfigValidate_GetByProjectConfigId",
CommandType = CommandType.StoredProcedure,
Parameters = lstParams
});
List <Models.CalificationProject.ConfigValidateModel> oReturn = new List <Models.CalificationProject.ConfigValidateModel>();
if (response.DataTableResult != null && response.DataTableResult.Rows.Count > 0)
{
oReturn = (from cvm in response.DataTableResult.AsEnumerable()
where !cvm.IsNull("CalificationProjectConfigValidateId")
group cvm by new
{
CalificationProjectConfigValidateId = cvm.Field <int>("CalificationProjectConfigValidateId"),
CalificationProjectConfigId = cvm.Field <int>("CalificationProjectConfigId"),
OperatorId = cvm.Field <int>("OperatorId"),
OperatorName = cvm.Field <string>("OperatorName"),
Value = cvm.Field <string>("Value"),
Result = cvm.Field <string>("Result"),
Enable = cvm.Field <UInt64>("Enable") == 1 ? true : false,
CreateDate = cvm.Field <DateTime>("CreateDate"),
LastModify = cvm.Field <DateTime>("LastModify")
}
into cvmf
select new Models.CalificationProject.ConfigValidateModel()
{
CalificationProjectConfigValidateId = cvmf.Key.CalificationProjectConfigValidateId,
CalificationProjectConfigId = cvmf.Key.CalificationProjectConfigId,
Operator = new Company.Models.Util.CatalogModel
{
ItemId = cvmf.Key.OperatorId,
ItemName = cvmf.Key.OperatorName
},
Value = cvmf.Key.Value,
Result = cvmf.Key.Result,
Enable = cvmf.Key.Enable,
CreateDate = cvmf.Key.CreateDate,
LastModify = cvmf.Key.LastModify
}).ToList();
}
return(oReturn);
}
public List <ChangesControlModel> ChangesControlSearch(string SearchParam, int PageNumber, int RowCount, out int TotalRows)
{
TotalRows = 0;
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vSearchParam", SearchParam));
lstParams.Add(DataInstance.CreateTypedParameter("vPageNumber", PageNumber));
lstParams.Add(DataInstance.CreateTypedParameter("vRowCount", RowCount));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "P_ChangesControl_Search",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
List <ChangesControlModel> oReturn = new List <ChangesControlModel>();
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
TotalRows = response.DataTableResult.Rows[0].Field <int>("TotalRows");
oReturn =
(from c in response.DataTableResult.AsEnumerable()
where !c.IsNull("ProviderPublicId")
select new ChangesControlModel()
{
ProviderPublicId = c.Field <string>("ProviderPublicId"),
Name = c.Field <string>("ProviderName"),
IdentificationNumber = c.Field <string>("IdentificationNumber"),
IdentificationType = new CatalogModel()
{
ItemId = c.Field <int>("IdentificationTypeId"),
ItemName = c.Field <string>("IdentificationType"),
},
Status = new CatalogModel()
{
ItemId = c.Field <int>("StatusId"),
ItemName = c.Field <string>("Status"),
},
FormUrl = c.Field <string>("FormPublicId"),
StepId = c.Field <int>("StepId"),
Enable = c.Field <UInt64>("ChangeEnable") == 1 ? true : false,
LastModify = c.Field <DateTime>("LastModify"),
}).ToList();
}
return(oReturn);
}
public List <LogManager.Models.LogModel> ProviderLog(string ProviderPublicId)
{
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vProviderPublicId", ProviderPublicId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "P_ProviderLog_ByPublicId",
CommandType = CommandType.StoredProcedure,
Parameters = lstParams,
});
List <LogManager.Models.LogModel> oReturn = null;
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn =
(from l in response.DataTableResult.AsEnumerable()
where !l.IsNull("LogId")
group l by new
{
LogId = l.Field <int>("LogId"),
User = l.Field <string>("User"),
Source = l.Field <string>("Source"),
LogInfoId = l.Field <int>("LogInfoId"),
LogInfoType = l.Field <string>("LogInfoType"),
Name = l.Field <string>("Name"),
CreateDate = l.Field <DateTime>("CreateDate"),
}
into li
select new LogManager.Models.LogModel()
{
LogId = li.Key.LogId,
User = li.Key.User,
Source = li.Key.Source,
CreateDate = li.Key.CreateDate,
RelatedLogInfo = new List <LogManager.Models.LogInfoModel>()
{
new LogManager.Models.LogInfoModel()
{
LogInfoId = li.Key.LogInfoId,
LogInfoType = li.Key.LogInfoType,
Value = li.Key.Name,
}
}
}).ToList();
}
return(oReturn);
}
public List <Models.CalificationProject.ConfigItemModel> CalificationProjectConfigItem_GetByCalificationProjectConfigId(int CalificationProjectConfigId, bool Enable)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vCalificationProjectConfigId", CalificationProjectConfigId));
lstParams.Add(DataInstance.CreateTypedParameter("vEnable", Enable == true ? 1 : 0));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "CC_CalificationProjectConfigItem_GetByConfigId",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams,
});
List <Models.CalificationProject.ConfigItemModel> oReturn = new List <Models.CalificationProject.ConfigItemModel>();
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
oReturn =
(from cit in response.DataTableResult.AsEnumerable()
where !cit.IsNull("CalificationProjectConfigId")
group cit by new
{
CalificationProjectConfigItemId = cit.Field <int>("CalificationProjectConfigItemId"),
CalificationProjectConfigId = cit.Field <int>("CalificationProjectConfigId"),
CalificationProjectConfigItemName = cit.Field <string>("CalificationProjectConfigItemName"),
CalicationProjecConfigItemTypeId = cit.Field <int>("CalicationProjecConfigItemTypeId"),
CalicationProjecConfigItemTypeName = cit.Field <string>("CalicationProjecConfigItemTypeName"),
Enable = cit.Field <UInt64>("Enable") == 1 ? true : false,
LastModify = cit.Field <DateTime>("LastModify"),
CreateDate = cit.Field <DateTime>("CreateDate"),
}
into citg
select new Models.CalificationProject.ConfigItemModel()
{
CalificationProjectConfigItemId = citg.Key.CalificationProjectConfigItemId,
CalificationProjectConfigItemName = citg.Key.CalificationProjectConfigItemName,
CalificationProjectConfigItemType = new Company.Models.Util.CatalogModel()
{
ItemId = citg.Key.CalicationProjecConfigItemTypeId,
ItemName = citg.Key.CalicationProjecConfigItemTypeName,
},
Enable = citg.Key.Enable,
LastModify = citg.Key.LastModify,
CreateDate = citg.Key.CreateDate,
}).ToList();
}
return(oReturn);
}
public void NotificationDeleteById(int NotificationId)
{
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vNotificationId", NotificationId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.NonQuery,
CommandText = "N_Notification_DeleteById",
CommandType = CommandType.StoredProcedure,
Parameters = lstParams,
});
}
public List <Interfaces.Models.AsociateProvider.AsociateProviderModel> GetAllAsociateProvider(string SearchParam, int PageNumber, int RowCount, out int TotalRows)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vSearchParam", SearchParam));
lstParams.Add(DataInstance.CreateTypedParameter("vPageNumber", PageNumber));
lstParams.Add(DataInstance.CreateTypedParameter("vRowCount", RowCount));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "AP_GetAllAsociateProviders",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams,
});
TotalRows = 0;
List <Interfaces.Models.AsociateProvider.AsociateProviderModel> oReturn = null;
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
TotalRows = response.DataTableResult.Rows[0].Field <int>("TotalRows");
oReturn =
(from ap in response.DataTableResult.AsEnumerable()
where !ap.IsNull("AsociateProviderId")
select new AsociateProvider.Interfaces.Models.AsociateProvider.AsociateProviderModel()
{
AsociateProviderId = ap.Field <int>("AsociateProviderId"),
RelatedProviderBO = new Interfaces.Models.AsociateProvider.RelatedProviderModel()
{
ProviderPublicId = ap.Field <string>("BO_ProviderPublicId"),
ProviderName = ap.Field <string>("BO_ProviderName"),
IdentificationType = ap.Field <int>("BO_IdentificationType").ToString(),
IdentificationNumber = ap.Field <string>("BO_IdentificationNumber"),
},
RelatedProviderDM = new Interfaces.Models.AsociateProvider.RelatedProviderModel()
{
ProviderPublicId = ap.Field <string>("DM_ProviderPublicId"),
ProviderName = ap.Field <string>("DM_ProviderName"),
IdentificationType = ap.Field <int>("DM_IdentificationType").ToString(),
IdentificationNumber = ap.Field <string>("DM_IdentificationNumber")
},
Email = ap.Field <string>("UserEmail"),
CreateDate = ap.Field <DateTime>("CreateDate"),
LastModify = ap.Field <DateTime>("LastModify"),
}).ToList();
}
return(oReturn);
}
public void FieldDelete(int FieldId)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vFieldId", FieldId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.NonQuery,
CommandText = "F_Field_Delete",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
}
public void FileUsedCreate(string Url)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vUrl", Url));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.NonQuery,
CommandText = "F_FileUsed_Create",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
}
public List <SanofiComercialInfoModel> GetComercialInfoByProvider(string vProviderPublicId)
{
List <System.Data.IDbDataParameter> lstparams = new List <System.Data.IDbDataParameter>();
lstparams.Add(DataInstance.CreateTypedParameter("vProviderPublicId", vProviderPublicId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "Sanofi_GetComercialInfo",
CommandType = CommandType.StoredProcedure,
Parameters = lstparams,
});
List <SanofiComercialInfoModel> oReturn = new List <SanofiComercialInfoModel>();
if (response.DataTableResult != null && response.DataTableResult.Rows.Count > 0)
{
oReturn =
(
from sci in response.DataTableResult.AsEnumerable()
where !sci.IsNull("CompanyId")
group sci by new
{
CompanyId = sci.Field <int>("CompanyId"),
CompanyName = sci.Field <string>("CompanyName"),
IdentificationNumber = sci.Field <string>("IdentificationNumber"),
FiscalNumber = sci.Field <string>("FiscalNumber"),
NIF_Type = sci.Field <string>("NIF_Type"),
PayCondition = sci.Field <string>("PayCondition"),
GroupSchemaProvider = sci.Field <int>("GroupSchemaProvider"),
ContactName = sci.Field <string>("ContactName"),
ComprasCod = sci.Field <string>("ComprasCod"),
}
into scig
select new SanofiComercialInfoModel()
{
CompanyId = scig.Key.CompanyId,
CompanyName = scig.Key.CompanyName,
IdentificationNumber = scig.Key.IdentificationNumber,
FiscalNumber = scig.Key.FiscalNumber,
NIFType = scig.Key.NIF_Type,
PayCondition = scig.Key.PayCondition,
GroupSchemaProvider = scig.Key.GroupSchemaProvider,
ContactName = scig.Key.ContactName,
BuyCod = scig.Key.ComprasCod
}).ToList();
}
return(oReturn);
}
public void DeleteUserRoles(int AplicationRoleId)
{
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vApplicationRoleId", AplicationRoleId));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.NonQuery,
CommandText = "A_ApplicationRole_Delete",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
}
public void FormUpsertLogo(string FormPublicId, string Logo)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vFormPublicId", FormPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vLogo", Logo));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.NonQuery,
CommandText = "F_Form_UpsertLogo",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
}
public void StepModify(int StepId, string Name, int Position)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vStepId", StepId));
lstParams.Add(DataInstance.CreateTypedParameter("vName", Name));
lstParams.Add(DataInstance.CreateTypedParameter("vPosition", Position));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.NonQuery,
CommandText = "F_Step_Modify",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
}
public void LogInfoCreate(int LogId, string LogInfoType, string Value)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vLogId", LogId));
lstParams.Add(DataInstance.CreateTypedParameter("vLogInfoType", LogInfoType));
lstParams.Add(DataInstance.CreateTypedParameter("vValue", Value));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.NonQuery,
CommandText = "L_LogInfo_Create",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams
});
}
public void AP_AsociateProviderUpsert(string BOProviderPublicId, string DMProviderPublicId, string Email)
{
List <System.Data.IDbDataParameter> lstParams = new List <System.Data.IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vDM_ProviderPublicId", DMProviderPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vBO_ProviderPublicId", BOProviderPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vUserEmail", Email));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.Scalar,
CommandText = "AP_AsociateProviderUpsert",
CommandType = System.Data.CommandType.StoredProcedure,
Parameters = lstParams,
});
}
public void AP_AsociateRelatedCustomerProvider(string CustomerPublicId, string ProviderPublicId, bool Enable)
{
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vCustomerPublicId", CustomerPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vProviderPublicId", ProviderPublicId));
lstParams.Add(DataInstance.CreateTypedParameter("vEnable", Enable == true ? 1 : 0));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.NonQuery,
CommandText = "AP_RelatedCustomer",
CommandType = CommandType.StoredProcedure,
Parameters = lstParams,
});
}
