public UserPortalAdmin DataTableToElementForUserPortal(DataTable table) { UserPortalAdmin vResult = null; try { foreach (DataRow row in table.Rows) { vResult = new UserPortalAdmin() { Id = Guid.Parse(row["id"].ToString()), UserName = row["username"].ToString(), Password = row["password"].ToString(), FirstName = row["firstname"].ToString(), SecondName = row["secondname"].ToString(), FirstLastName = row["firstLastname"].ToString(), SecondLastName = row["secondLastname"].ToString(), Email = row["email"].ToString(), UrlPhoto = row["urlphoto"].ToString(), BirthDate = Convert.ToDateTime(row["birthdate"]), Phone = row["phone"].ToString(), IdCompany = Guid.Parse(row["idcompany"].ToString()), State = Convert.ToInt32(row["state"]), UserCreate = row["usercreate"].ToString(), DateCreate = Convert.ToDateTime(row["datecreate"]) }; } } catch (Exception) { vResult = null; } return(vResult); }
public string UpdateStateUserPortal(UserPortalAdmin valUserPortal) { string vResult = "4"; SQLToolsLibrary vSqlTools = new SQLToolsLibrary(); try { int valState = VerifyState(valUserPortal.State); if (valState < 2) { List <SqlParameter> valParameterList = new List <SqlParameter> { new SqlParameter("@Id", valUserPortal.Id), new SqlParameter("@State", valState) }; bool vSuccessUpdate = vSqlTools.ExecuteIUWithStoreProcedure(valParameterList, "sp_Update_State_User_Portal", vConnection); if (vSuccessUpdate) { vResult = "1"; } } } catch (Exception vEx) { string vMsg = vEx.Message; vResult = "3"; } return(vResult); }
public string UpdateUserPortal(UserPortalAdmin valUSerPortal) { string vResult = "4"; try { SQLToolsLibrary vSqlTools = new SQLToolsLibrary(); List <SqlParameter> vListofParameters = new List <SqlParameter> { new SqlParameter("@Id", valUSerPortal.Id), new SqlParameter("@Password", !string.IsNullOrEmpty(valUSerPortal.Password)?valUSerPortal.Password:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@FirstName", !string.IsNullOrEmpty(valUSerPortal.FirstName)?valUSerPortal.FirstName:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@SecondName", valUSerPortal.SecondName), new SqlParameter("@FirstLastname", !string.IsNullOrEmpty(valUSerPortal.FirstLastName)?valUSerPortal.FirstLastName:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@SecondLastName", valUSerPortal.SecondLastName), new SqlParameter("@UrlPhoto", valUSerPortal.UrlPhoto), new SqlParameter("@BirthDate", valUSerPortal.BirthDate != DateTime.MinValue ? valUSerPortal.BirthDate : new DateTime(1900, 1, 1)), new SqlParameter("@Phone", valUSerPortal.Phone), new SqlParameter("@backmail", !string.IsNullOrEmpty(valUSerPortal.Backmail)?valUSerPortal.Backmail:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@IdCompany", valUSerPortal.IdCompany != Guid.Empty?valUSerPortal.IdCompany:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@UserUpdate", !string.IsNullOrEmpty(valUSerPortal.UserUpdate)?valUSerPortal.UserUpdate:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@DateUpdate", DateTime.Now), }; bool vSuccessUpdate = vSqlTools.ExecuteIUWithStoreProcedure(vListofParameters, "sp_Update_User_Portal", vConnection); if (vSuccessUpdate) { vResult = "1"; } } catch (Exception e) { string vMsg = e.Message; vResult = "3"; } return(vResult); }
// POST: api/UserPortal public async Task <IHttpActionResult> Post([FromBody] UserPortalAdmin valUser) { string vResponse = "4"; IUserPortalAdminData vUserData = new UserPortalAdminData(); try { bool vVerifyIsNull = VerifyNullFielUserPortal(valUser); if (vVerifyIsNull) { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.NotAcceptable, Message = Messages.vNotInserted, Result = vResponse }))); } vResponse = await vUserData.InsertUserPortal(valUser); if (!string.IsNullOrEmpty(vResponse) && vResponse == "1") { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.OK, Message = Messages.vOkInserted, Result = vResponse }))); } if (!string.IsNullOrEmpty(vResponse) && vResponse == "2") { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.NotAcceptable, Message = Messages.vEmailDuplicated, Result = vResponse }))); } } catch (Exception) { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, new { Code = HttpStatusCode.InternalServerError, Message = Messages.vInternalServerError, Result = vResponse }))); } return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.NotAcceptable, Message = Messages.vNotInserted, Result = vResponse }))); }
public async Task <string> InsertUserPortal(UserPortalAdmin valUser) { string vResult = "4"; try { UserPortalAdmin vUserExist = SelectUserPortalByEmail(valUser.UserName); if (vUserExist != null) { vResult = "2"; } else if (vUserExist == null) { string vUrl = await UploadAzureHelper.UploadFilesToBlobStorageContainer(valUser.Photo?.NameFile, valUser.Photo?.FileData); SQLToolsLibrary vSqlTools = new SQLToolsLibrary(); List <SqlParameter> vListofParameters = new List <SqlParameter> { new SqlParameter("@Id", valUser.Id != Guid.Empty ? valUser.Id : Guid.NewGuid()), new SqlParameter("@UserName", !string.IsNullOrEmpty(valUser.UserName)?valUser.UserName:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@Password", !string.IsNullOrEmpty(valUser.Password)?valUser.Password:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@FirstName", !string.IsNullOrEmpty(valUser.FirstName)?valUser.FirstName:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@SecondName", valUser.SecondName), new SqlParameter("@FirstLastname", !string.IsNullOrEmpty(valUser.FirstLastName)?valUser.FirstLastName:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@SecondLastName", valUser.SecondLastName), new SqlParameter("@Email", !string.IsNullOrEmpty(valUser.UserName)?valUser.UserName:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@UrlPhoto", !string.IsNullOrEmpty(vUrl) ? vUrl : string.Empty), new SqlParameter("@BirthDate", valUser.BirthDate != DateTime.MinValue ? valUser.BirthDate : new DateTime(1900, 1, 1)), new SqlParameter("@Phone", valUser.Phone), new SqlParameter("@backmail", !string.IsNullOrEmpty(valUser.Backmail)?valUser.Backmail:string.Empty), new SqlParameter("@IdCompany", valUser.IdCompany != Guid.Empty?valUser.IdCompany:throw new Exception(GlobalValues.vTextExceptionParameterNull)), new SqlParameter("@State", valUser.State), new SqlParameter("@UserCreate", valUser.UserCreate /*!string.IsNullOrEmpty(valUser.UserCreate)?valUser.UserCreate:throw new Exception(GlobalValues.vTextExceptionParameterNull)*/), new SqlParameter("@DateCreate", valUser.DateCreate != DateTime.MinValue ? valUser.DateCreate : DateTime.Now) }; bool vSuccessInsert = vSqlTools.ExecuteIUWithStoreProcedure(vListofParameters, "sp_Insert_UserPortal", vConnection); if (vSuccessInsert) { vResult = "1"; } } } catch (Exception e) { string vMsg = e.Message; vResult = "3"; } return(vResult); }
public IHttpActionResult UpdateStateUserPortal([FromBody] UserPortalAdmin valUserPortal) { string vResponse = "4"; IUserPortalAdminData vUserData = new UserPortalAdminData(); try { vResponse = vUserData.UpdateStateUserPortal(valUserPortal); if (!string.IsNullOrEmpty(vResponse) && vResponse == "1") { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.OK, Message = Messages.vOkUpdated, Result = vResponse }))); } } catch (Exception vEx) { string vMessage = vEx.Message; return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, new { Code = HttpStatusCode.InternalServerError, Message = Messages.vInternalServerError, Result = vResponse }))); } return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.NotAcceptable, Message = Messages.vNotInserted, Result = vResponse }))); }
public UserPortalAdmin SelectUserPortalByEmail(string email) { UserPortalAdmin vResult = null; DataTable vDatainTable = new DataTable(); SQLToolsLibrary vSqlTools = new SQLToolsLibrary(); try { List <SqlParameter> vListofParameters = new List <SqlParameter> { new SqlParameter("@Email", email) }; vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vListofParameters, "sp_Select_UserPortal_Email", vConnection); vResult = DataTableToElementForUserPortal(vDatainTable); } catch (Exception) { vResult = null; } return(vResult); }
public bool VerifyNullFielUserPortal(UserPortalAdmin valUserPortalAdmin) { bool vResult = false; if (valUserPortalAdmin.UserName == string.Empty) { vResult = true; return(vResult); } if (valUserPortalAdmin.Password == string.Empty) { vResult = true; return(vResult); } if (valUserPortalAdmin.FirstName == string.Empty) { vResult = true; return(vResult); } if (valUserPortalAdmin.FirstLastName == string.Empty) { vResult = true; return(vResult); } if (valUserPortalAdmin.Phone == string.Empty) { vResult = true; return(vResult); } if (valUserPortalAdmin.IdCompany == Guid.Empty) { vResult = true; return(vResult); } if (valUserPortalAdmin.State > 1) { vResult = true; return(vResult); } return(vResult); }
public IHttpActionResult ValidateUserPortal([FromBody] UserPortalAdmin valUserPortal) { bool vResult = false; IUserPortalAdminData vUserData = new UserPortalAdminData(); try { string vUserName = valUserPortal.UserName; string vPassword = valUserPortal.Password; string vResponse = string.Empty; vResponse = vUserData.VerifyUserPortal(vUserName, vPassword); if (!string.IsNullOrEmpty(vResponse)) { vResult = true; return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.OK, Message = Messages.vLoginSuccessfully, Result = vResponse }))); } } catch (Exception) { return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, new { Code = HttpStatusCode.InternalServerError, Message = Messages.vInternalServerError, Result = vResult.ToString() }))); } return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.NotAcceptable, Message = Messages.vLoginUnsuccessfully, Result = vResult.ToString() }))); }
public string SelectUserPortalById(Guid Id) { string vResult = "4"; DataTable vDatainTable = new DataTable(); SQLToolsLibrary VSqlTools = new SQLToolsLibrary(); try { List <SqlParameter> vParameterList = new List <SqlParameter> { new SqlParameter("@Id", Id != Guid.Empty?Id:throw new Exception(GlobalValues.vTextExceptionParameterNull)) }; vDatainTable = VSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_select_UserPortal_ById", vConnection); UserPortalAdmin vData = DataTableToSelectUser(vDatainTable); if (vData.UserName != null) { vResult = JsonConvert.SerializeObject(vData, Formatting.Indented); } } catch (Exception vEx) { string vMessage = vEx.Message; vResult = "3"; } return(vResult); }
public UserPortalAdmin DataTableToSelectUser(DataTable table) { UserPortalAdmin vResult = new UserPortalAdmin(); try { foreach (DataRow row in table.Rows) { UserPortalAdmin valUserPortal = new UserPortalAdmin { Id = Guid.Parse(Convert.ToString(row["Id"])), UserName = !string.IsNullOrEmpty(Convert.ToString(row["UserName"])) ? Convert.ToString(row["UserName"]) : string.Empty, Password = !string.IsNullOrEmpty(Convert.ToString(row["Password"])) ? Convert.ToString(row["Password"]) : string.Empty, FirstName = !string.IsNullOrEmpty(Convert.ToString(row["FirstName"])) ? Convert.ToString(row["FirstName"]) : string.Empty, SecondName = !string.IsNullOrEmpty(Convert.ToString(row["SecondName"])) ? Convert.ToString(row["SecondName"]) : string.Empty, FirstLastName = !string.IsNullOrEmpty(Convert.ToString(row["FirstLastName"])) ? Convert.ToString(row["FirstLastName"]) : string.Empty, SecondLastName = !string.IsNullOrEmpty(Convert.ToString(row["SecondLastName"])) ? Convert.ToString(row["SecondLastName"]) : string.Empty, Email = !string.IsNullOrEmpty(Convert.ToString(row["Email"])) ? Convert.ToString(row["Email"]) : string.Empty, UrlPhoto = !string.IsNullOrEmpty(Convert.ToString(row["UrlPhoto"])) ? Convert.ToString(row["UrlPhoto"]) : string.Empty, BirthDate = row["BirthDate"] != DBNull.Value ? Convert.ToDateTime(row["BirthDate"]) : DateTime.MinValue, Phone = !string.IsNullOrEmpty(Convert.ToString(row["Phone"])) ? Convert.ToString(row["Phone"]) : string.Empty, Backmail = !string.IsNullOrEmpty(Convert.ToString(row["Backmail"])) ? Convert.ToString(row["Backmail"]) : string.Empty, IdCompany = Guid.Parse(Convert.ToString(row["IdCompany"])), CompanyName = !string.IsNullOrEmpty(Convert.ToString(row["CompanyName"])) ? Convert.ToString(row["CompanyName"]) : string.Empty, State = Convert.ToInt32(row["State"]), UserCreate = !string.IsNullOrEmpty(Convert.ToString(row["UserCreate"])) ? Convert.ToString(row["UserCreate"]) : string.Empty, DateCreate = row["DateCreate"] != DBNull.Value ? Convert.ToDateTime(row["DateCreate"]) : DateTime.MinValue, UserUpdate = !string.IsNullOrEmpty(Convert.ToString(row["UserUpdate"])) ? Convert.ToString(row["UserUpdate"]) : string.Empty, DateUpdate = row["DateUpdate"] != DBNull.Value ? Convert.ToDateTime(row["DateUpdate"]) : DateTime.MinValue, }; //vResult.Add(valUserPortal); vResult = valUserPortal; } } catch (Exception vEx) { string vMessage = vEx.Message; vResult = new UserPortalAdmin(); } return(vResult); }