public static void UpdateDietitian(DietitianE obj)
{
SqlCommand com = new SqlCommand("UpdateDietitian", Connection.Con); // Prodecure
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@id", obj.DietitianID));
com.Parameters.Add(new SqlParameter("@address", obj.Address));
com.Parameters.Add(new SqlParameter("@cv", obj.CV));
com.Parameters.Add(new SqlParameter("@dietitianEmail", obj.DietitianEmail));
com.Parameters.Add(new SqlParameter("@dietitianLicense", obj.DietitianLicense));
com.Parameters.Add(new SqlParameter("@dietitianName", obj.DietitianName));
com.Parameters.Add(new SqlParameter("@dietitianPassword", obj.DietitianPassword));
com.Parameters.Add(new SqlParameter("@dietitianPhone", obj.DietitianPhone));
com.Parameters.Add(new SqlParameter("@dietitianSurname", obj.DietitianSurname));
com.Parameters.Add(new SqlParameter("@gender", obj.Gender));
if (com.Connection.State == ConnectionState.Closed)
{
com.Connection.Open();
}
SqlDataReader rd = com.ExecuteReader();
com.Dispose();
com.Connection.Close();
}
public static int InsertDietitian(DietitianE dietitian)
{
SqlCommand com = new SqlCommand("InsertDietitian", Connection.Con); // Prodecure
com.CommandType = CommandType.StoredProcedure;
if (dietitian.Address == null)
{
com.Parameters.Add(new SqlParameter("@address", DBNull.Value));
}
else
{
com.Parameters.Add(new SqlParameter("@address", dietitian.Address));
}
com.Parameters.Add(new SqlParameter("@name", dietitian.DietitianName));
com.Parameters.Add(new SqlParameter("@surname", dietitian.DietitianSurname));
com.Parameters.Add(new SqlParameter("@email", dietitian.DietitianEmail));
com.Parameters.Add(new SqlParameter("@password", dietitian.DietitianPassword));
if (dietitian.DietitianPhone != null)
{
com.Parameters.Add(new SqlParameter("@phone", dietitian.DietitianPhone));
}
else
{
com.Parameters.Add(new SqlParameter("@phone", DBNull.Value));
}
com.Parameters.Add(new SqlParameter("@cv", dietitian.CV));
com.Parameters.Add(new SqlParameter("@license", dietitian.DietitianLicense));
com.Parameters.Add(new SqlParameter("@gender", dietitian.Gender));
if (com.Connection.State == ConnectionState.Closed)
{
com.Connection.Open();
}
SqlDataReader rd = com.ExecuteReader();
int insertId = 0;
if (rd.HasRows)
{
rd.Read();
insertId = Convert.ToInt32(rd[0]);
}
com.Dispose();
com.Connection.Close();
return(insertId);
}
public static DietitianE ValidateDietitian(string email, string password)
{
DietitianE dietitian = null;
SqlCommand com = new SqlCommand("ValidateDietitian", Connection.Con); // Prodecure
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@Email", email));
com.Parameters.Add(new SqlParameter("@Password", password));
if (com.Connection.State == ConnectionState.Closed)
{
com.Connection.Open();
}
SqlDataReader rd = com.ExecuteReader();
if (rd.HasRows)
{
if (rd.Read())
{
dietitian = new DietitianE
{
DietitianID = Convert.ToInt32(rd["DietitianID"]),
Address = rd["Address"] == DBNull.Value ? "" : rd["Address"].ToString(),
CV = rd["CV"] == DBNull.Value ? "" : rd["CV"].ToString(),
DietitianPhone = rd["DietitianPhone"] == DBNull.Value ? "" : rd["DietitianPhone"].ToString(),
DietitianEmail = rd["DietitianEmail"].ToString(),
DietitianLicense = rd["DietitianLicense"].ToString(),
DietitianName = rd["DietitianName"].ToString(),
DietitianPassword = rd["DietitianPassword"].ToString(),
DietitianSurname = rd["DietitianSurname"].ToString(),
Gender = rd["Gender"] == DBNull.Value ? "" : rd["Gender"].ToString()
};
}
}
com.Dispose();
com.Connection.Close();
return(dietitian);
}
// All of dietitian information get from Dietitian Table
public static DietitianE GetDietitianByDietitianID(int dietitianID)
{
DietitianE dietitian = null;
SqlCommand com = new SqlCommand("getDietitianByDietitianID", Connection.Con); // Prodecure
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@dietitianID", dietitianID));
if (com.Connection.State == ConnectionState.Closed)
{
com.Connection.Open();
}
SqlDataReader rd = com.ExecuteReader();
if (rd.HasRows)
{
if (rd.Read())
{
dietitian = new DietitianE // Fill new Dietitian Entitiy
{
DietitianID = Convert.ToInt32(rd["DietitianID"]),
Address = rd["Address"].ToString(),
DietitianLicense = rd["DietitianLicense"].ToString(),
CV = rd["CV"].ToString(),
DietitianPhone = rd["DietitianPhone"].ToString(),
DietitianEmail = rd["DietitianEmail"].ToString(),
DietitianName = rd["DietitianName"].ToString(),
DietitianPassword = rd["DietitianPassword"].ToString(),
DietitianSurname = rd["DietitianSurname"].ToString()
};
}
}
com.Dispose();
com.Connection.Close();
return(dietitian);
}
public static int insertDietitian(DietitianE dietitian)
{
return(DietitianC.InsertDietitian(dietitian));
}
public static void updateDietitian(DietitianE obj)
{
DietitianC.UpdateDietitian(obj);
}
