/// <summary> /// This Method will be used to Select data from tbl_subCategory table /// </summary> /// <param name="objPaymentPlan">ID,Action</param> /// <returns>1 for success and -1 for fail</returns> public int SelectRecord(PropPaymentPlan objPaymentPlan) { //proc_UDS_PaymentPlan is the stored procedure name which will be used to select data from the table SqlCommand cmd = new SqlCommand("proc_UDS_PaymentPlan", objCon.Con); return(cmd.ExecuteNonQuery()); }
/// <summary> /// This Method will be used to Update data into the table /// </summary> /// <param name="objPaymentPlan">Plan Name,Cost,Duration,Action,ID</param> /// <returns>1 for success and -1 for fail</returns> public int UpdatePaymentPlan(PropPaymentPlan objPaymentPlan) { //proc_UDS_PaymentPlan is the stored procedure name which will be used to Update data into the table SqlCommand cmd = new SqlCommand("proc_UDS_PaymentPlan", objCon.Con); return(cmd.ExecuteNonQuery()); }
/// <summary> /// This Method is used to Select data /// </summary> /// <param name="objProperty">Action</param> /// <returns>1 for success and -1 for fail</returns> public int RecordSelect(PropPaymentPlan objProperty) { DllPaymentPlan objDal = new DllPaymentPlan(); try { return(objDal.SelectRecord(objProperty)); } catch (Exception info) { throw info; } finally { objDal = null; } }