public RegisterOutputModel AddWebCustomerCompany(RegisterInputModel input) { var res = new RegisterOutputModel(); using (IDbConnection db = new SqlConnection(Global.Connection)) { var p = new DynamicParameters(); p.Add("@password", input.password); p.Add("@Street", input.Address); p.Add("@Phone1", input.Phone1); p.Add("@Mobile", input.Mobile); p.Add("@whatsapp", input.WhatsApp); p.Add("@skype", input.Skype); p.Add("@f", input.f); p.Add("@e_mail", input.e_mail); p.Add("@Cust_ID_Main", input.Cust_ID_Main); p.Add("@Cust_ID", dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@Comp_ID", dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@AuthCode", dbType: DbType.String, direction: ParameterDirection.Output, size: 50); p.Add("@AuthPass", dbType: DbType.String, direction: ParameterDirection.Output, size: 20); p.Add("@Txt", dbType: DbType.String, direction: ParameterDirection.Output, size: 4000); var procRes = db.Execute("sp_AddWebCustomerCompany", p, commandType: CommandType.StoredProcedure); res = new RegisterOutputModel { Cust_ID = p.Get <int>("@Cust_ID"), Comp_ID = p.Get <int>("@Comp_ID"), AuthCode = p.Get <string>("@AuthCode"), AuthPass = p.Get <string>("@AuthPass"), Txt = p.Get <string>("@Txt") }; } return(res); }
public IActionResult Put([FromBody] RegisterInputModel model) { RegisterOutputModel regOutputModel = repo.AddWebCustomerCompany(model); if (!ModelState.IsValid) { return(BadRequest()); } if (regOutputModel.Cust_ID == 999999 && regOutputModel.AuthCode.Length == 0) { regOutputModel.Result = false; return(Ok(regOutputModel)); } return(Ok(regOutputModel)); }
public RegisterResponseModel Register(RegisterInputModel data, RoleEnum roleEnum) { UserRepository userRepo = new UserRepository(DbContext); var checkUserName = userRepo.FindByUserName(data.Username); if (checkUserName == null) { Guid id = Guid.NewGuid(); User temp = new User(); temp.ID = id; temp.PasswordHash = data.Password.ConvertToMD5(); temp.FirstName = data.FirstName; temp.LastName = data.LastName; temp.UserName = data.Username; temp.PhoneNumber = data.NoTelp; temp.CreateDate = DateTime.Now; temp.CreateByUserID = id; if (roleEnum == RoleEnum.MediaOwner || roleEnum == RoleEnum.MediaBuyer) { temp.IsActive = false; } else { temp.IsActive = true; } userRepo = new UserRepository(DbContext); var response = userRepo.Insert(temp, false); //insert ke table userRole UserRole userRole = new UserRole(); RoleRepository roleRepo = new RoleRepository(DbContext); userRole.ID = Guid.NewGuid(); userRole.UserID = temp.ID; //RoleID di ambil dari table role userRole.RoleID = roleRepo.GetRole((int)roleEnum).FirstOrDefault().ID; userRole.CreateDate = DateTime.Now; userRole.CreateByUserID = id; UserRoleRepository userRoleRepository = new UserRoleRepository(DbContext); var res2 = userRoleRepository.Insert(userRole, false); //INSERT TO COMPANY TABLE Company dataComp = new Company(); dataComp.ID = Guid.NewGuid(); dataComp.NPWP = data.NPWP; dataComp.Website = data.Website; dataComp.Alamat = data.Alamat; dataComp.CompanyName = data.NamaPerusahaan; dataComp.Email = data.EmailPerusahaan; dataComp.UserID = temp.ID; dataComp.Kategory = data.Kategori; dataComp.CreateByUserID = id; dataComp.CreateDate = DateTime.Now; CompanyRepository comRepo = new CompanyRepository(DbContext); comRepo.Insert(dataComp, false); //INSERT TO TABLE CONTACT ContactPerson temCon = new ContactPerson(); temCon.ID = Guid.NewGuid(); temCon.CompanyID = dataComp.ID; temCon.Email = data.Username; temCon.Name = data.FirstName + " " + data.LastName; temCon.UserID = temp.ID; temCon.CreateDate = DateTime.Now; temCon.CreateByUserID = id; ContactPersonRepository conRepo = new ContactPersonRepository(DbContext); conRepo.Insert(temCon, true); RegisterResponseModel result = new RegisterResponseModel(); result.Message = response.Message; result.Response = response.Result; RegisterOutputModel output = new RegisterOutputModel(); output.FirstName = temp.FirstName; output.LastName = temp.LastName; output.UserName = temp.UserName; output.UserID = temp.ID; result.data = output; result.Message = "Daftar berhasil."; result.Response = true; return(result); } else { RegisterResponseModel result = new RegisterResponseModel(); result.Message = "Email sudah terdaftar!!"; result.Response = false; return(result); } }