public DataTable fetch(CatProp p) { try { con.Open(); SqlCommand cmd = new SqlCommand("catSP", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tag", p._tag); cmd.Parameters.AddWithValue("@Cat_ID", p._Cat_ID); cmd.Parameters.AddWithValue("@Sub_ID", p._Sub_ID); cmd.Parameters.AddWithValue("@Name", p._Name); cmd.Parameters.AddWithValue("@SubName", p._SubName); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } catch (Exception e) { con.Close(); return(null); } finally { con.Close(); } }
public DataTable fetchBal(CatProp pr) { try { CatDal dal = new CatDal(); return(dal.fetch(pr)); } catch (Exception e) { return(null); } }
public int AddBal(CatProp pr) { try { CatDal dal = new CatDal(); return(dal.Add(pr)); } catch (Exception e) { return(0); } }
public int Add(CatProp p) { try { con.Open(); SqlCommand cmd = new SqlCommand("catSP", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tag", p._tag); cmd.Parameters.AddWithValue("@Cat_ID", p._Cat_ID); cmd.Parameters.AddWithValue("@Sub_ID", p._Sub_ID); cmd.Parameters.AddWithValue("@Name", p._Name); cmd.Parameters.AddWithValue("@SubName", p._SubName); return(cmd.ExecuteNonQuery()); } catch (Exception e) { con.Close(); return(0); } finally { con.Close(); } }