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