public Mem_RAJUK GetMem_RAJUKFromReader(IDataReader reader)
{
try
{
Mem_RAJUK mem_RAJUK = new Mem_RAJUK
(
(int)reader["Mem_RAJUKID"],
(int)reader["Mem_MemberID"],
reader["MembershipNo"].ToString(),
reader["RAJUKRegistrationNo"].ToString(),
reader["Batch"].ToString(),
reader["ExamDate"].ToString(),
reader["Telephone"].ToString(),
reader["Email"].ToString(),
(char)reader["TypeOfMemeber"],
(int)reader["MembershipNoValue"],
reader["MembershipNoValueChar"].ToString()
);
return(mem_RAJUK);
}
catch (Exception ex)
{
return(null);
}
}
public static Mem_RAJUK GetMem_RAJUKByID(int id)
{
Mem_RAJUK mem_RAJUK = new Mem_RAJUK();
SqlMem_RAJUKProvider sqlMem_RAJUKProvider = new SqlMem_RAJUKProvider();
mem_RAJUK = sqlMem_RAJUKProvider.GetMem_RAJUKByID(id);
return(mem_RAJUK);
}
public bool UpdateMem_RAJUK(Mem_RAJUK mem_RAJUK)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateMem_RAJUK", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Mem_RAJUKID", SqlDbType.Int).Value = mem_RAJUK.Mem_RAJUKID;
cmd.Parameters.Add("@Mem_MemberID", SqlDbType.Int).Value = mem_RAJUK.Mem_MemberID;
cmd.Parameters.Add("@MembershipNo", SqlDbType.NVarChar).Value = mem_RAJUK.MembershipNo;
cmd.Parameters.Add("@RAJUKRegistrationNo", SqlDbType.NVarChar).Value = mem_RAJUK.RAJUKRegistrationNo;
cmd.Parameters.Add("@Batch", SqlDbType.NChar).Value = mem_RAJUK.Batch;
cmd.Parameters.Add("@ExamDate", SqlDbType.NVarChar).Value = mem_RAJUK.ExamDate;
cmd.Parameters.Add("@Telephone", SqlDbType.NVarChar).Value = mem_RAJUK.Telephone;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = mem_RAJUK.Email;
cmd.Parameters.Add("@TypeOfMemeber", SqlDbType.Char).Value = mem_RAJUK.TypeOfMemeber;
cmd.Parameters.Add("@MembershipNoValue", SqlDbType.Int).Value = mem_RAJUK.MembershipNoValue;
cmd.Parameters.Add("@MembershipNoValueChar", SqlDbType.NChar).Value = mem_RAJUK.MembershipNoValueChar;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static bool UpdateMem_RAJUK(Mem_RAJUK mem_RAJUK)
{
SqlMem_RAJUKProvider sqlMem_RAJUKProvider = new SqlMem_RAJUKProvider();
return(sqlMem_RAJUKProvider.UpdateMem_RAJUK(mem_RAJUK));
}
public static int InsertMem_RAJUK(Mem_RAJUK mem_RAJUK)
{
SqlMem_RAJUKProvider sqlMem_RAJUKProvider = new SqlMem_RAJUKProvider();
return(sqlMem_RAJUKProvider.InsertMem_RAJUK(mem_RAJUK));
}
