public CategaryModel CategoryDetails(int cid)
{
CategaryModel details = new CategaryModel();
string query = "select * FROM public.rm_photoalbum where album_id=@album_id";
con.Open();
cmd = new NpgsqlCommand(query, con);
cmd.Parameters.Add(new NpgsqlParameter("@album_id", cid));
try
{
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
details.album_id = Convert.ToInt32(dr["cid"]);
details.album_categary = dr["album_categary"].ToString();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(details);
}
public int addCategory(CategaryModel cat)
{
int i = 0;
string query = "INSERT INTO public.rm_photoalbum(album_categary) VALUES(@album_categary)";
con.Open();
cmd = new NpgsqlCommand(query, con);
cmd.Parameters.Add(new NpgsqlParameter("@album_categary", cat.album_categary));
try
{
i = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(i);
}
public List <CategaryModel> getAllCategory()
{
List <CategaryModel> categorys = new List <CategaryModel>();
string query = "SELECT *FROM public.rm_photoalbum";
con.Open();
cmd = new NpgsqlCommand(query, con);
try
{
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
CategaryModel category = new CategaryModel();
category.album_id = Convert.ToInt32(dr["album_id"]);
category.album_categary = dr["album_categary"].ToString();
categorys.Add(category);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(categorys);
}
public IHttpActionResult AddCategary(CategaryModel model)
{
CategaryModel cat = new CategaryModel();
cat.album_categary = model.album_categary;
int i = categaryRepo.addCategory(cat);
if (i >= 1)
{
return(Ok("Succefully Added"));
}
else
{
return(BadRequest("Not a valid Detail/Request"));
}
}
public IHttpActionResult UpdateCategary(CategaryModel model)
{
CategaryModel cat = new CategaryModel();
cat.album_categary = model.album_categary;
cat.album_id = model.album_id;
int i = categaryRepo.editCategory(cat);
if (i >= 1)
{
return(Ok("Updated Succefully"));
}
else
{
return(BadRequest("Not a valid Detail/Request"));
}
}
public int editCategory(CategaryModel cat)
{
int i = 0;
string query = "UPDATE public.rm_photoalbum SET album_categary=@album_categary WHERE album_id=@album_id";
con.Open();
cmd = new NpgsqlCommand(query, con);
cmd.Parameters.AddWithValue("@album_id", cat.album_id);
cmd.Parameters.AddWithValue("@album_categary", cat.album_categary);
try
{
i = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(i);
}