/// <summary>
/// Запрос всех наименований монитора
/// </summary>
/// <returns></returns>
public string AllNameMonitor()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.NameMonitors));
}
public Response GetClientCompleteRegistration(string email)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_UpdateByEmailForChangePassword");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
};
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorResetPassword"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorResetPassword"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response GetInformationClient(string email)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_GetInformationClient");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
List <MyInformationResponse.FinishedModule> addfinishedModules = new List <MyInformationResponse.FinishedModule>();
if (!string.IsNullOrEmpty(dataTable.Rows[0]["MODULOS_TERMINADOS"].ToString()))
{
addfinishedModules.AddRange(from string item in dataTable.Rows[0]["MODULOS_TERMINADOS"].ToString().Split("@")
let moduleFinish = new MyInformationResponse.FinishedModule()
{
ModuleNumber = Convert.ToInt32(item.Substring(0, item.IndexOf(":"))),
Coupon = item.Substring(item.IndexOf(":") + 1)
}
select moduleFinish);
}
MyInformationResponse result = new MyInformationResponse
{
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Ci = dataTable.Rows[0]["CLIE_CI_VC"].ToString(),
NameComplete = dataTable.Rows[0]["CLIE_NOMBRE_COMPLETO_VC"].ToString(),
Gender = dataTable.Rows[0]["CLIE_GENERO_VC"].ToString(),
Birthdate = Convert.ToDateTime(dataTable.Rows[0]["CLIE_FECHA_NACIMIENTO_DT"]),
Age = Convert.ToInt32(dataTable.Rows[0]["CLIE_EDAD_IN"]),
Department = dataTable.Rows[0]["CLIE_DEPARTAMENTO_VC"].ToString(),
City = dataTable.Rows[0]["CLIE_CIUDAD_VC"].ToString(),
Address = dataTable.Rows[0]["CLIE_DIRECCION_VC"].ToString(),
CellPhone = dataTable.Rows[0]["CLIE_NUMERO_CELULAR_VC"].ToString(),
Phone = dataTable.Rows[0]["CLIE_NUMERO_FIJO_VC"].ToString(),
EducationLevel = dataTable.Rows[0]["CLIE_NIVEL_EDUCACION_VC"].ToString(),
Disability = Convert.ToBoolean(dataTable.Rows[0]["CLIE_DISCAPACIDAD_BT"]),
TypeDisability = Convert.ToString(dataTable.Rows[0]["CLIE_TIPO_DISCAPACIDAD_VC"]),
ReferenceName = dataTable.Rows[0]["CLIE_NOMBRE_REFERENCIA_VC"].ToString(),
ReferenceCellphone = dataTable.Rows[0]["CLIE_CELULAR_REFERENCIA_VC"].ToString(),
Role = Convert.ToInt32(dataTable.Rows[0]["CLIE_ROL_IN"]) == 1 ? "User" : "Admin",
CompleteRegister = Convert.ToBoolean(dataTable.Rows[0]["CLIE_REGISTRO_COMPLETO_BT"]),
CurrentModule = Convert.ToInt32(dataTable.Rows[0]["MODULO_ACTUAL"]),
finishedModules = addfinishedModules
};
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ParticipantDoesNotExist"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ParticipantDoesNotExist"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response SendEmail(string to, string subject, string withOriginMessage, string withoutOriginMessage, string header, string origin, string link, string token = "", string numberModule = "", string coupon = "", string contestDate = "")
{
Response response = new Response();
string finalMessage = "";
if (!Validate.ToEmail(to))
{
var validate = Response.Error(to, "InvalidEmail");
response.Data = null;
response.Message = validate.Message;
response.State = validate.State;
return(response);
}
MailAddress _fromMailAddress = new MailAddress(_from);
MailMessage message = new MailMessage();
if (_flagEnableUserPassword)
{
var basicCredential = new NetworkCredential(_user, _password);
_client.UseDefaultCredentials = false;
_client.EnableSsl = true;
_client.Credentials = basicCredential;
_client.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
}
if (!string.IsNullOrEmpty(origin))
{
finalMessage = _message.Replace("@message", withOriginMessage);
}
else
{
finalMessage = _message.Replace("@message", withoutOriginMessage);
}
message.Subject = subject;
message.IsBodyHtml = true;
message.From = _fromMailAddress;
var bodyMessage = "";
foreach (var item in to.Split(';'))
{
if (!string.IsNullOrEmpty(item))
{
message.To.Add(item);
bodyMessage = finalMessage.Replace("@email", item).Replace("@link", link).Replace("@Bussines", _from).Replace("@header", header).Replace("@token", token).Replace("@numeroModulo", numberModule).Replace("@cupon", coupon).Replace("@fecha", contestDate);
message.Body = bodyMessage;
/*AlternateView view = AlternateView.CreateAlternateViewFromString(bodyMessage, null, MediaTypeNames.Text.Html);
*
* LinkedResource resource = new LinkedResource(string.Format(@"{0}/Resources/MailImages/header-bg.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)),"image/png");
* resource.ContentId = "id1";
* resource.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource);
*
* LinkedResource resource2 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/module-completed.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource2.ContentId = "id2";
* resource2.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource2);
*
* LinkedResource resource3 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/bg-mail.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource3.ContentId = "id3";
* resource3.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource3);
*
* LinkedResource resource4 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/click-logo.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource4.ContentId = "id4";
* resource4.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource4);
*
* LinkedResource resource5 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/ecofuturo-logo.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource5.ContentId = "id5";
* resource5.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource5);
*
* LinkedResource resource6 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/bg-ticket.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource6.ContentId = "id6";
* resource6.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource6);
*
* message.AlternateViews.Add(view);
* bodyMessage = "";*/
}
}
ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true;
try
{
_client.Send(message);
return(Response.Success(true));
}
catch (Exception ex)
{
Logger.Error("Message: {0}; Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(to, "InvalidEmail"));
}
}
public Response GetClientValitated(string email, string password)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_GetClientValitated");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
storeProcedure.AddParameter("@CLIE_CLAVE_VC", password);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
NameComplete = dataTable.Rows[0]["CLIE_NOMBRE_COMPLETO_VC"].ToString(),
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Password = dataTable.Rows[0]["CLIE_CLAVE_VC"].ToString(),
Role = Convert.ToInt32(dataTable.Rows[0]["CLIE_ROL_IN"]) == 0 ? Role.Admin : Role.User,
IsVerified = Convert.ToBoolean(dataTable.Rows[0]["CLIE_ESTADO_VERIFICACION_BT"]),
CompleteRegister = Convert.ToBoolean(dataTable.Rows[0]["CLIE_REGISTRO_COMPLETO_BT"]),
CurrentModule = Convert.ToInt32(dataTable.Rows[0]["MODULO_ACTUAL"])
};
if (BC.Verify(password, result.Password))
{
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("02"))
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("AccountNotValidated"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "AccountNotValidated"));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
/// <summary>
/// Вытаскиваем все производители
/// </summary>
/// <returns></returns>
public string AllProducer()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.Database.SqlQuery <Producer>("Select * From Producer")));
}
/// <summary>
/// Получение\выгрузка всех праздничных дней
/// </summary>
/// <returns></returns>
public string GetHolidays()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibrary(Inventory.Rb_Holidays));
}
/// <summary>
/// Все производители серверного оборудования
/// </summary>
/// <returns></returns>
public string ManufacturerSeverEquipment()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.ManufacturerSeverEquipments));
}
/// <summary>
/// Выгрузка поставщиков
/// </summary>
/// <returns></returns>
public string Supply()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibrary(Inventory.Supplies));
}
/// <summary>
/// Получение ресурсов для заявки
/// </summary>
/// <returns></returns>
public string GetResourceIt()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.ResourceIts));
}
/// <summary>
/// Получение журнала заявок на различные ресурсы
/// </summary>
/// <returns></returns>
public string GetJournalAis3()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.JournalAis3));
}
/// <summary>
/// Все серверное оборудование
/// </summary>
/// <returns></returns>
public string ServerEquipment()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.ServerEquipments.Where(x => !x.WriteOffSign)));
}
/// <summary>
/// Выгрузка бесперебойников
/// </summary>
/// <returns></returns>
public string BlockPower()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.BlockPowers.Where(x => !x.WriteOffSign)));
}
/// <summary>
/// Выгрузка типов серверов
/// </summary>
/// <returns></returns>
public string TypeServer()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.TypeServers));
}
/// <summary>
/// Запрос всех параметров для процесса
/// </summary>
/// <returns></returns>
public string AllEventProcessParameter()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.EventProcesses, "dd.MM.yyyy HH:mm"));
}
/// <summary>
/// Выгрузка производителей бесперебойных блоков
/// </summary>
/// <returns></returns>
public string ProizvoditelBlockPower()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.ProizvoditelBlockPowers));
}
/// <summary>
/// Вытаскиваем все категории
/// </summary>
/// <returns></returns>
public string AllFullСategories()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.Database.SqlQuery <FullСategory>("Select * From FullСategory")));
}
/// <summary>
/// Статистика актулизации пользователей
/// </summary>
/// <returns></returns>
public string ActualsUsersKladr()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.UsersIsActualsStats));
}
/// <summary>
/// Вытаскиваем все модели
/// </summary>
/// <returns></returns>
public string AllEquipmentModel()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.Database.SqlQuery <EquipmentModel>("Select * From EquipmentModel")));
}
/// <summary>
/// Получение всей классификации
/// </summary>
/// <returns></returns>
public string AllClasification()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.Classifications));
}
public Response Insert(Core.Entity.ConsumptionHistory consumptionHistory)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.HISTORIAL_CONSUMO_API_ECOFUTURO_Insert");
storeProcedure.AddParameter("@HIAE_WEAP_NOMBRE_VC", consumptionHistory.ApiName);
storeProcedure.AddParameter("@HIAE_HOST_VC", consumptionHistory.Host);
storeProcedure.AddParameter("@HIAE_ID_CORRELACION_VC", consumptionHistory.CorrelationId);
storeProcedure.AddParameter("@HIAE_APP_USUARIO_ID_VC", consumptionHistory.AppUserId);
storeProcedure.AddParameter("@HIAE_SOLICITUD_VC", consumptionHistory.Request);
storeProcedure.AddParameter("@HIAE_FECHA_SOLICITUD_DT", consumptionHistory.DateRequest);
storeProcedure.AddParameter("@HIAE_RESPUESTA_VC", consumptionHistory.Response);
storeProcedure.AddParameter("@HIAE_FECHA_RESPUESTA_DT", consumptionHistory.DateResponse);
storeProcedure.AddParameter("@HIAE_CODIGO_RESPUESTA_VC", consumptionHistory.CodeResponse);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["@@IDENTITY"]) > 0)
{
return(Response.Success(Convert.ToInt64(dataTable.Rows[0]["@@IDENTITY"].ToString())));
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Success(0));
}
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Success(0));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
/// <summary>
/// Все идентификаторы пользователей
/// </summary>
/// <returns></returns>
public string AllMailIdentifier()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.MailIdentifiers));
}
public Response UpdateRegistrationComplete(Core.Entity.Client client, string userModification)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_UpdateRegistrationComplete");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", client.Email);
storeProcedure.AddParameter("@CLIE_NOMBRE_COMPLETO_VC", client.NameComplete);
storeProcedure.AddParameter("@CLIE_GENERO_VC", client.Gender);
storeProcedure.AddParameter("@CLIE_FECHA_NACIMIENTO_DT", client.Birthdate);
storeProcedure.AddParameter("@CLIE_EDAD_IN", client.Age);
storeProcedure.AddParameter("@CLIE_DEPARTAMENTO_VC", client.Department);
storeProcedure.AddParameter("@CLIE_CIUDAD_VC", client.City);
storeProcedure.AddParameter("@CLIE_DIRECCION_VC", client.Address);
storeProcedure.AddParameter("@CLIE_NUMERO_CELULAR_VC", client.CellPhone);
storeProcedure.AddParameter("@CLIE_NUMERO_FIJO_VC", client.Phone);
storeProcedure.AddParameter("@CLIE_NIVEL_EDUCACION_VC", client.EducationLevel);
storeProcedure.AddParameter("@CLIE_DISCAPACIDAD_BT", client.Disability);
storeProcedure.AddParameter("@CLIE_TIPO_DISCAPACIDAD_VC", client.TypeDisability);
storeProcedure.AddParameter("@CLIE_NOMBRE_REFERENCIA_VC", client.ReferenceName);
storeProcedure.AddParameter("@CLIE_CELULAR_REFERENCIA_VC", client.ReferencePhone);
storeProcedure.AddParameter("@CLIE_USUARIO_MODIFICACION_VC", userModification);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["@@ROWCOUNT"]) > 0)
{
return(Response.Success(Convert.ToInt64(dataTable.Rows[0]["@@ROWCOUNT"].ToString())));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorRegistrationComplete"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorRegistrationComplete"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("Sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "Sql"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
/// <summary>
/// Все группы пользователей
/// </summary>
/// <returns></returns>
public string AllMailGroup()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.MailGroups));
}
public Response UpdateClientForgotPassword(string email, string resetToken)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_UpdateClientForgotPassword");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
storeProcedure.AddParameter("@CLIE_RESTABLECER_TOKEN_VERIFICACION_EMAIL_VC", resetToken);
storeProcedure.AddParameter("@CLIE_FECHA_EXPIRACION_TOKEN_RESTABLECER_DT", DateTime.UtcNow.AddDays(1));
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
ResetToken = dataTable.Rows[0]["CLIE_RESTABLECER_TOKEN_VERIFICACION_EMAIL_VC"].ToString()
};
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorGeneredTokeRefresh"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorGeneredTokeRefresh"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
/// <summary>
/// Запрос на все шаблоны СТО для заявок
/// </summary>
/// <returns></returns>
public string AllTemplate()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.FullTemplateSupports));
}
public Response InsertIfNotexist(Core.Entity.Client client)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_InsertIfNotexist");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", client.Email);
storeProcedure.AddParameter("@CLIE_CI_VC", client.Ci);
storeProcedure.AddParameter("@CLIE_CI_EXPEDICION_VC", client.CiExpedition);
storeProcedure.AddParameter("@CLIE_CLAVE_VC", client.Password);
storeProcedure.AddParameter("@CLIE_TERMINOS_Y_CONDICIONES_ACEPTADOS_BT", client.AcceptTerms);
storeProcedure.AddParameter("@CLIE_TOKEN_VERIFICACION_EMAIL_VC", client.VerificationTokenEmail);
storeProcedure.AddParameter("@CLIE_ROL_IN", 1);
storeProcedure.AddParameter("@CLIE_USUARIO_CREACION_VC", client.CreationUser);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
Id = Convert.ToInt64(dataTable.Rows[0]["CLIE_CLIENTE_ID_BI"]),
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Ci = dataTable.Rows[0]["CLIE_CI_VC"].ToString(),
CiExpedition = dataTable.Rows[0]["CLIE_CI_EXPEDICION_VC"].ToString(),
VerificationTokenEmail = dataTable.Rows[0]["CLIE_TOKEN_VERIFICACION_EMAIL_VC"].ToString(),
};
return(Response.Success(result));
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("AlreadyRegisteredEmail"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "AlreadyRegisteredEmail"));
}
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("Sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "Sql"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
/// <summary>
/// Все токены ключи в БД
/// </summary>
/// <returns></returns>
public string AllToken()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.Tokens.Where(x => !x.WriteOffSign)));
}
public Response GetWinners()
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_GetWinnerbyModule");
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
WinnersdResponse result = new WinnersdResponse();
result.Winners.AddRange(from DataRow dataRow in dataTable.Rows
let winner = new WinnersdResponse.Winner()
{
Position = Convert.ToInt32(dataRow["POSITION"]),
Email = dataRow["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Ci = dataRow["CLIE_CI_VC"].ToString(),
NameComplete = dataRow["CLIE_NOMBRE_COMPLETO_VC"].ToString(),
Gender = dataRow["CLIE_GENERO_VC"].ToString(),
Birthdate = Convert.ToDateTime(dataRow["CLIE_FECHA_NACIMIENTO_DT"]),
Age = Convert.ToInt32(dataRow["CLIE_EDAD_IN"]),
Department = dataRow["CLIE_DEPARTAMENTO_VC"].ToString(),
City = dataRow["CLIE_CIUDAD_VC"].ToString(),
Address = dataRow["CLIE_DIRECCION_VC"].ToString(),
CellPhone = dataRow["CLIE_NUMERO_CELULAR_VC"].ToString(),
Phone = Convert.ToString(dataRow["CLIE_NUMERO_FIJO_VC"]),
EducationLevel = dataRow["CLIE_NIVEL_EDUCACION_VC"].ToString(),
Disability = Convert.ToBoolean(dataRow["CLIE_DISCAPACIDAD_BT"]),
TypeDisability = Convert.ToString(dataRow["CLIE_TIPO_DISCAPACIDAD_VC"]),
ReferenceName = Convert.ToString(dataRow["CLIE_NOMBRE_REFERENCIA_VC"]),
ReferenceCellphone = Convert.ToString(dataRow["CLIE_CELULAR_REFERENCIA_VC"]),
Role = Convert.ToInt32(dataTable.Rows[0]["CLIE_ROL_IN"]) == 1 ? "User" : "Admin",
CompleteRegister = Convert.ToBoolean(dataRow["CLIE_REGISTRO_COMPLETO_BT"]),
CurrentModule = Convert.ToInt32(dataRow["MODULO_ACTUAL"]),
NumberModuleFinished = Convert.ToInt32(dataRow["NUMERO_MODULOS_TERMINADOS"]),
ModulesFinishComplete = dataRow["MODULOS_TERMINADOS"].ToString()
}
select winner);
List <WinnersdResponse.Winner.FinishedModule> addfinishedModules = new List <WinnersdResponse.Winner.FinishedModule>();
foreach (var winner in result.Winners)
{
if (string.IsNullOrEmpty(winner.ModulesFinishComplete))
{
break;
}
foreach (string module in winner.ModulesFinishComplete.Split("@"))
{
var finishModule = module.Split(":");
winner.FinishedModules.Add(new WinnersdResponse.Winner.FinishedModule
{
ModuleNumber = Convert.ToInt32(finishModule[0]),
Coupon = finishModule[1].ToString()
});
}
}
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorGetWinners"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorGetWinners"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
/// <summary>
/// Запрос всех наименований системных блоков
/// </summary>
/// <returns></returns>
public string NameSysBlock()
{
SerializeJson json = new SerializeJson();
return(json.JsonLibaryIgnoreDate(Inventory.NameSysBlocks));
}
