public virtual int Delete(PL_DepartmentMaster prp) { MyConnection Mycon = new MyConnection(); Mycon.cmd.CommandText = "[USP_M_DEPARTMENT_MASTER]"; Mycon.cmd.CommandType = CommandType.StoredProcedure; Mycon.cmd.Parameters.AddWithValue("@spType", prp.sptype); Mycon.cmd.Parameters.AddWithValue("@TableID", prp.TableID); SqlParameter p2 = new SqlParameter("@msg", SqlDbType.VarChar, 200); p2.Direction = ParameterDirection.Output; Mycon.cmd.Parameters.Add(p2); try { Mycon.Open(); int retvalue = Mycon.cmd.ExecuteNonQuery(); Mycon.Close(); prp.msg = Mycon.cmd.Parameters["@msg"].Value.ToString(); return(retvalue); } catch (Exception ex) { prp.msg = ex.Message.ToString(); return(0); } finally { if (Mycon.Mycon.State == ConnectionState.Open) { Mycon.Close(); } Mycon.cmd.Dispose(); } }
public virtual int insert(PL_DepartmentMaster prp) { MyConnection Mycon = new MyConnection(); Mycon.cmd.CommandText = "[USP_M_DEPARTMENT_MASTER]"; Mycon.cmd.CommandType = CommandType.StoredProcedure; Mycon.cmd.Parameters.AddWithValue("@DepartmentCode", prp.DepartmentCode); Mycon.cmd.Parameters.AddWithValue("@sptype", prp.sptype); Mycon.cmd.Parameters.AddWithValue("@DepartmentName", prp.DepartmentName); Mycon.cmd.Parameters.AddWithValue("@PayBillSignAuth", prp.PayBillSighAuth); Mycon.cmd.Parameters.AddWithValue("@PayBillSighAuthUpload", prp.PayBillSighAuthUpload); Mycon.cmd.Parameters.AddWithValue("@CreatedBy", prp.CreatedBy); SqlParameter p1 = new SqlParameter("@TableID", SqlDbType.VarChar, 10); p1.Direction = ParameterDirection.InputOutput; p1.Value = prp.TableID; Mycon.cmd.Parameters.Add(p1); SqlParameter p2 = new SqlParameter("@msg", SqlDbType.VarChar, 200); p2.Direction = ParameterDirection.Output; Mycon.cmd.Parameters.Add(p2); try { Mycon.Open(); int RetValue = Mycon.cmd.ExecuteNonQuery(); Mycon.Close(); prp.msg = Mycon.cmd.Parameters["@msg"].Value.ToString(); return(RetValue); } catch (Exception ex) { prp.msg = ex.Message.ToString(); return(0); } finally { if (Mycon.Mycon.State == ConnectionState.Open) { Mycon.Close(); } Mycon.cmd.Dispose(); } }
public DataTable BindGrid(PL_DepartmentMaster prp) { MyConnection Mycon = new MyConnection(); Mycon.Open(); Mycon.cmd.CommandText = "USP_M_DEPARTMENT_MASTER"; Mycon.cmd.CommandType = CommandType.StoredProcedure; Mycon.cmd.Parameters.AddWithValue("@spType", prp.sptype); Mycon.cmd.Parameters.AddWithValue("@TableID", prp.TableID); SqlParameter p1 = new SqlParameter("@msg", SqlDbType.VarChar, 200); p1.Direction = ParameterDirection.Output; Mycon.cmd.Parameters.Add(p1); SqlDataReader dr = Mycon.cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr); Mycon.Close(); return(dt); }
public DataTable Bindgrid(PL_DepartmentMaster prp) { DL_DepartmentMaster obj = new DL_DepartmentMaster(); return(obj.BindGrid(prp)); }
public virtual int Delete(PL_DepartmentMaster prp) { DL_DepartmentMaster obj = new DL_DepartmentMaster(); return(obj.Delete(prp)); }
public virtual int insert(PL_DepartmentMaster prp) { DL_DepartmentMaster obj = new DL_DepartmentMaster(); return(obj.insert(prp)); }