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;
}
}