public bool Create(UserViewModel model, bool create_emp)
{
string msgError = "";
try
{
var xxx = MessageConvert.SerializeObject(model.objectjson_person);
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "sp_user_create",
"@create_employee", create_emp,
"@user_id", model.user_id,
"@username", model.username,
"@password", model.password,
"@language_code", model.language_code,
"@domain_name", model.domain_name,
"@description_l", model.description_l,
"@description_e", model.description_e,
"@access_token", model.access_token,
"@created_by_user_id", model.created_by_user_id,
"@objectjson_employee", MessageConvert.SerializeObject(model.objectjson_employee),
"@objectjson_person", MessageConvert.SerializeObject(model.objectjson_person));
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update(UserViewModel model)
{
string msgError = "";
try
{
var vv = MessageConvert.SerializeObject(model.objectjson_person);
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "sp_user_update",
"@user_id", model.user_id,
"@username", model.username,
"@language_code", model.language_code,
"@domain_name", model.domain_name,
"@description_l", model.description_l,
"@description_e", model.description_e,
"@lu_user_id", model.lu_user_id,
"@objectjson_person", MessageConvert.SerializeObject(model.objectjson_person));
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Create(HoaDonModel model)
{
string msgError = "";
try
{
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "sp_hoa_don_create",
"@ma_hoa_don", model.ma_hoa_don,
"@ho_ten", model.ho_ten,
"@dia_chi", model.dia_chi,
"@listjson_chitiet", model.listjson_chitiet != null ? MessageConvert.SerializeObject(model.listjson_chitiet) : null);
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}