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