/// <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)); }