public DataTable Bindgrid(PL_Designation pl) { MyConnection con = new MyConnection(); DataTable dt = new DataTable(); con.Open(); con.cmd.CommandText = "Sp_Designation"; con.cmd.CommandType = CommandType.StoredProcedure; con.cmd.Parameters.Add("@ParentID", pl.ParentID); con.cmd.Parameters.Add("@sptype", pl.sptype); SqlParameter p2 = new SqlParameter("@msg", SqlDbType.VarChar, 2000); p2.Direction = ParameterDirection.Output; con.cmd.Parameters.Add(p2); SqlParameter p1 = new SqlParameter("@ID", SqlDbType.Int); p1.Direction = ParameterDirection.InputOutput; p1.Value = pl.TableID; con.cmd.Parameters.Add(p1); SqlDataReader sdr; sdr = con.cmd.ExecuteReader(); dt.Load(sdr); con.Close(); return(dt); }
public virtual int Insert(PL_Designation pl) { MyConnection con = new MyConnection(); con.cmd.CommandText = "[Sp_Designation]"; con.cmd.CommandType = CommandType.StoredProcedure; con.cmd.Parameters.Add("@HName", pl.HName); con.cmd.Parameters.Add("@SHName", pl.SHName); con.cmd.Parameters.Add("@Name", pl.Name); con.cmd.Parameters.Add("@sptype", pl.sptype); con.cmd.Parameters.Add("@ParentID", pl.ParentID); con.cmd.Parameters.Add("@TreeLevel", pl.TreeLevel); con.cmd.Parameters.Add("@ParentDesignationID", pl.MyList); con.cmd.Parameters.Add("@DesignationID", pl.TableID); SqlParameter p1 = new SqlParameter("@ID", SqlDbType.Int); p1.Value = pl.TableID; p1.Direction = ParameterDirection.InputOutput; con.cmd.Parameters.Add(p1); SqlParameter p2 = new SqlParameter("@msg", SqlDbType.VarChar, 200); p2.Direction = ParameterDirection.Output; con.cmd.Parameters.Add(p2); try { con.Open(); int RetValue = con.cmd.ExecuteNonQuery(); con.Close(); pl.msg = con.cmd.Parameters["@msg"].Value.ToString(); return(RetValue); } catch (Exception ex) { pl.msg = ex.Message; return(0); } finally { if (con.Mycon.State == ConnectionState.Open) { con.Close(); } con.cmd.Dispose(); } }
public DataTable BindGrid(PL_Designation pl) { DL_Designation obj = new DL_Designation(); return(obj.Bindgrid(pl)); }
public virtual int Insert(PL_Designation pl) { DL_Designation obj = new DL_Designation(); return(obj.Insert(pl)); }