public bool AddNewOption(Option option) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@name", option.Name) }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_OptionsInsert]", CommandType.StoredProcedure, parameters));; }
public void Delete(int resourceId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@resourceId", resourceId), }; SqlDBHelper.ExecuteNonQuery("[Resource_Control].[SP_DeleteResource]", CommandType.StoredProcedure, parameters); }
public bool DeleteRes_Opt_Junc(int res_opt_ID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", res_opt_ID) }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_res_opt_juncDelete]", CommandType.StoredProcedure, parameters)); }
public bool AddNewRes_Opt_Junc(Res_Opt_Junc res_opt_junc) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Res_id", res_opt_junc.Res_id), new SqlParameter("@Opt_id", res_opt_junc.Opt_id), }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_res_opt_juncInsert]", CommandType.StoredProcedure, parameters));; }
public bool AddNewLocation(Location loc) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@name", loc.Name), new SqlParameter("@address", loc.Address) }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_LocationsInsert]", CommandType.StoredProcedure, parameters));; }
public bool AddNewCategory(Category category) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@name", category.Name), new SqlParameter("@description", category.Description) }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_CategoryInsert]", CommandType.StoredProcedure, parameters));; }
//**************** public bool DeleteOption(int optID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", optID) }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_OptionsDelete]", CommandType.StoredProcedure, parameters)); }
public bool UpdateOption(Option option) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", option.ID), new SqlParameter("@name", option.Name), }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_OptionsUpdate]", CommandType.StoredProcedure, parameters)); }
public bool UpdateLocation(Location loc, string oldname) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@oldname", oldname), new SqlParameter("@name", loc.Name), new SqlParameter("@address", loc.Address) }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_LocationUpdate]", CommandType.StoredProcedure, parameters)); }
public bool UpdateRes_Opt_Junc(Res_Opt_Junc res_opt_junc) { SqlParameter[] parameters = new SqlParameter[] { // new SqlParameter("@ID",res_opt_junc.ID), new SqlParameter("@Res_Id", res_opt_junc.Res_id), new SqlParameter("@Opt_Id", res_opt_junc.Opt_id), new SqlParameter("@IsActive", res_opt_junc.IsActive) }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_res_opt_juncUpdate]", CommandType.StoredProcedure, parameters)); }
//[Resource_Control].[SP_Log_Defence_LastDate_Sent_Sms] public bool AddOrUpdate_tbl_StudentDefence_Log(string mobile, bool IsShounatSms = false) { bool res = false; if (!string.IsNullOrEmpty(mobile)) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Mobile", mobile) , new SqlParameter("@IsShounatSms", IsShounatSms) }; res = SqlDBHelper.ExecuteNonQuery("[Resource_Control].[SP_AddOrUpdate_tbl_StudentDefence_Log]", CommandType.StoredProcedure, parameters); } return(res); }
public bool UpdateResource(Resource resource) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", resource.ID), new SqlParameter("@name", resource.Name), new SqlParameter("@location", resource.Location), new SqlParameter("@description", resource.Description), new SqlParameter("@categoryID", resource.CategoryID), new SqlParameter("@IsDeleted", resource.IsDeleted), new SqlParameter("@capacity", resource.Capacity) }; return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_ResourceUpdate]", CommandType.StoredProcedure, parameters)); }
public void InsertIntoDefenceSmsLog(string fullName, string userID, int requestId, string mobile, bool?smsType, string smsResult, DateTime dateSendSms) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FullName", fullName), new SqlParameter("@StCode_OstCode", userID), new SqlParameter("@RequestId", requestId), new SqlParameter("@Mobile", mobile), new SqlParameter("@SmsType", smsType), new SqlParameter("@SmsResult", smsResult), new SqlParameter("@DateSendSms", dateSendSms) }; SqlDBHelper.ExecuteNonQuery("[Resource_Control].[SP_InsertIntoDefenceSmsLog]", CommandType.StoredProcedure, parameters); } catch (Exception x) { throw x; } }