public static SPR_VOICE GetSPR_VOICEByID(int id)
{
SPR_VOICE sPR_VOICE = new SPR_VOICE();
SqlSPR_VOICEProvider sqlSPR_VOICEProvider = new SqlSPR_VOICEProvider();
sPR_VOICE = sqlSPR_VOICEProvider.GetSPR_VOICEByID(id);
return(sPR_VOICE);
}
public int InsertSPR_VOICE(SPR_VOICE sPR_VOICE)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertSPR_VOICE", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SPR_VOICEID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@STYPE", SqlDbType.VarChar).Value = sPR_VOICE.STYPE;
cmd.Parameters.Add("@MRC", SqlDbType.VarChar).Value = sPR_VOICE.MRC;
cmd.Parameters.Add("@VCOMM", SqlDbType.Int).Value = sPR_VOICE.VCOMM;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@SPR_VOICEID"].Value);
}
}
public bool UpdateSPR_VOICE(SPR_VOICE sPR_VOICE)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateSPR_VOICE", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SPR_VOICEID", SqlDbType.Int).Value = sPR_VOICE.SPR_VOICEID;
cmd.Parameters.Add("@STYPE", SqlDbType.VarChar).Value = sPR_VOICE.STYPE;
cmd.Parameters.Add("@MRC", SqlDbType.VarChar).Value = sPR_VOICE.MRC;
cmd.Parameters.Add("@VCOMM", SqlDbType.Int).Value = sPR_VOICE.VCOMM;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public SPR_VOICE GetSPR_VOICEFromReader(IDataReader reader)
{
try
{
SPR_VOICE sPR_VOICE = new SPR_VOICE
(
(int)reader["SPR_VOICEID"],
reader["STYPE"].ToString(),
reader["MRC"].ToString(),
(int)reader["VCOMM"]
);
return(sPR_VOICE);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateSPR_VOICE(SPR_VOICE sPR_VOICE)
{
SqlSPR_VOICEProvider sqlSPR_VOICEProvider = new SqlSPR_VOICEProvider();
return(sqlSPR_VOICEProvider.UpdateSPR_VOICE(sPR_VOICE));
}
public static int InsertSPR_VOICE(SPR_VOICE sPR_VOICE)
{
SqlSPR_VOICEProvider sqlSPR_VOICEProvider = new SqlSPR_VOICEProvider();
return(sqlSPR_VOICEProvider.InsertSPR_VOICE(sPR_VOICE));
}
