public int DeleteSubscriptionPlan(ISubscriptionPlan isubscriptionplan) { Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS"); string sqlCommand = "proSubscriptionPlanDelete"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@ID_subscriptionplan", DbType.Int64, isubscriptionplan.MasterID); db.AddInParameter(dbCommand, "@CancelledUser", DbType.Int64, isubscriptionplan.UserCode); db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, isubscriptionplan.FK_Company); try { return(Convert.ToInt32(db.ExecuteScalar(dbCommand))); } catch (SqlException e) { //UpdateErrorLog(iTopic, e); throw e; } }
public DataTable SelectAllSubscriptionPlan(ISubscriptionPlan isubscriptionplan) { DataTable dtblSubscriptionPlan = new DataTable(); Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS"); string sqlCommand = "proSubscriptionPlanSelect"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@ID_SubscriptionPlan", DbType.String, isubscriptionplan.MasterID); db.AddInParameter(dbCommand, "@SubscriptionPlanCode", DbType.String, isubscriptionplan.SubscriptionPlanCode); db.AddInParameter(dbCommand, "@SubscriptionPlanName", DbType.String, isubscriptionplan.SubscriptionPlanName); db.AddInParameter(dbCommand, "@PageIndex", DbType.Int32, isubscriptionplan.PageIndex); db.AddInParameter(dbCommand, "@PageSize", DbType.Int32, isubscriptionplan.PageSize); db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, isubscriptionplan.FK_Company); try { dtblSubscriptionPlan = db.ExecuteDataSet(dbCommand).Tables[0]; return(dtblSubscriptionPlan); } catch (SqlException e) { throw e; } }
public Int32 UpdateSubscriptionPlan(ISubscriptionPlan isubscriptionplan) { Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS"); string sqlCommand = "proSubscriptionPlanUpdate"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@UserAction", DbType.Byte, isubscriptionplan.UserAction); db.AddInParameter(dbCommand, "@Active", DbType.Byte, isubscriptionplan.Active); db.AddInParameter(dbCommand, "@ID_SubscriptionPlan", DbType.String, isubscriptionplan.MasterID); db.AddInParameter(dbCommand, "@SubscriptionPlanCode", DbType.String, isubscriptionplan.SubscriptionPlanCode); db.AddInParameter(dbCommand, "@SubscriptionPlanName", DbType.String, isubscriptionplan.SubscriptionPlanName); db.AddInParameter(dbCommand, "@SubscriptionPlanHours", DbType.String, isubscriptionplan.SubscriptionPlanHours); db.AddInParameter(dbCommand, "@SortOrder", DbType.Int64, isubscriptionplan.SortOrder); db.AddInParameter(dbCommand, "@UserCode", DbType.Int64, isubscriptionplan.UserCode); db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, isubscriptionplan.FK_Company); try { return(Convert.ToInt32(db.ExecuteScalar(dbCommand))); } catch (SqlException e) { return(0); } }